--- layout: documentation title: Malloy Documentation footer: /generated/footers/examples/names.html ---

Name Game

You can find the complete source code for this model here.

The Data set consists of name, gender, state and year with the number of people that were born with that name in that gender, state and year.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  top: 10
  project: *
}
QUERY RESULTS
stategenderyearnamenumber
AKF1,910Elsie6
ALF1,910Annie482
ALF1,910Katie84
ALF1,910Alma82
ALF1,910Thelma65
ALF1,910Ellen38
ALF1,910Rebecca35
ALF1,910Estella21
ALF1,910Corine17
ALF1,910Margie17
[
  {
    "state": "AK",
    "gender": "F",
    "year": 1910,
    "name": "Elsie",
    "number": 6
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Annie",
    "number": 482
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Katie",
    "number": 84
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Alma",
    "number": 82
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Thelma",
    "number": 65
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Ellen",
    "number": 38
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Rebecca",
    "number": 35
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Estella",
    "number": 21
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Corine",
    "number": 17
  },
  {
    "state": "AL",
    "gender": "F",
    "year": 1910,
    "name": "Margie",
    "number": 17
  }
]
SELECT 
   base.state as state,
   base.gender as gender,
   base.year as year,
   base.name as name,
   base.number as number
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
LIMIT 10

The command above says query the table 'bigquery-public-data.usa_names.usa_1910_2013' and project (show) all the columns for the first 10 rows.

Grouping a query

In SQL there are basically two kinds of SELECT commands: SELECT ... GROUP BY and SELECT without a grouping. In malloy, these are two different commands. The command in malloy for SELECT ... GROUP BY is group_by. Since number and year are reserved words, we have to quote the names with back-tics.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  group_by: name
  aggregate: population is `number`.sum()
}
QUERY RESULTS
namepopulation
James4,942,431
John4,834,422
Robert4,718,787
Michael4,297,230
William3,822,209
Mary3,737,679
David3,549,801
Richard2,531,924
Joseph2,472,917
Charles2,244,693
Thomas2,212,781
Christopher1,987,490
Daniel1,842,964
Patricia1,569,570
Matthew1,538,689
Elizabeth1,492,404
Jennifer1,463,145
Linda1,447,601
Barbara1,424,203
Donald1,402,666
Anthony1,385,453
Paul1,355,711
Mark1,339,371
George1,321,652
Steven1,269,627
Kenneth1,259,720
Andrew1,228,080
Edward1,210,315
Joshua1,163,481
Brian1,156,495
Kevin1,148,680
Margaret1,120,766
Susan1,108,712
Ronald1,074,141
Timothy1,055,792
Dorothy1,052,570
Jessica1,038,359
Jason1,009,416
Sarah1,006,934
Betty985,364
Nancy984,185
Karen982,192
Jeffrey969,093
Lisa962,981
Ryan907,969
Gary896,637
Helen895,428
Sandra870,958
Nicholas867,231
Eric862,204
Jacob848,518
Stephen844,930
Ashley841,427
Donna826,714
Kimberly826,275
Frank818,197
Carol817,290
Jonathan803,723
Michelle803,162
Larry801,398
Emily779,755
Amanda769,292
Scott765,844
Justin757,273
Laura745,892
Melissa745,498
Raymond744,284
Deborah735,869
Brandon735,849
Stephanie732,651
Rebecca728,799
Ruth728,678
Anna719,803
Sharon718,701
Kathleen703,265
Cynthia703,175
Gregory701,504
Shirley686,079
Samuel681,358
Amy673,234
Benjamin664,328
Patrick655,434
Angela653,663
Jack634,113
Virginia621,448
Jerry618,105
Dennis610,894
Catherine606,029
Brenda604,067
Alexander598,944
Katherine593,220
Pamela591,307
Nicole576,870
Tyler576,031
Christine574,120
Henry571,539
Walter558,026
Peter553,789
Douglas552,666
Janet550,557
[
  {
    "name": "James",
    "population": 4942431
  },
  {
    "name": "John",
    "population": 4834422
  },
  {
    "name": "Robert",
    "population": 4718787
  },
  {
    "name": "Michael",
    "population": 4297230
  },
  {
    "name": "William",
    "population": 3822209
  },
  {
    "name": "Mary",
    "population": 3737679
  },
  {
    "name": "David",
    "population": 3549801
  },
  {
    "name": "Richard",
    "population": 2531924
  },
  {
    "name": "Joseph",
    "population": 2472917
  },
  {
    "name": "Charles",
    "population": 2244693
  },
  {
    "name": "Thomas",
    "population": 2212781
  },
  {
    "name": "Christopher",
    "population": 1987490
  },
  {
    "name": "Daniel",
    "population": 1842964
  },
  {
    "name": "Patricia",
    "population": 1569570
  },
  {
    "name": "Matthew",
    "population": 1538689
  },
  {
    "name": "Elizabeth",
    "population": 1492404
  },
  {
    "name": "Jennifer",
    "population": 1463145
  },
  {
    "name": "Linda",
    "population": 1447601
  },
  {
    "name": "Barbara",
    "population": 1424203
  },
  {
    "name": "Donald",
    "population": 1402666
  },
  {
    "name": "Anthony",
    "population": 1385453
  },
  {
    "name": "Paul",
    "population": 1355711
  },
  {
    "name": "Mark",
    "population": 1339371
  },
  {
    "name": "George",
    "population": 1321652
  },
  {
    "name": "Steven",
    "population": 1269627
  },
  {
    "name": "Kenneth",
    "population": 1259720
  },
  {
    "name": "Andrew",
    "population": 1228080
  },
  {
    "name": "Edward",
    "population": 1210315
  },
  {
    "name": "Joshua",
    "population": 1163481
  },
  {
    "name": "Brian",
    "population": 1156495
  },
  {
    "name": "Kevin",
    "population": 1148680
  },
  {
    "name": "Margaret",
    "population": 1120766
  },
  {
    "name": "Susan",
    "population": 1108712
  },
  {
    "name": "Ronald",
    "population": 1074141
  },
  {
    "name": "Timothy",
    "population": 1055792
  },
  {
    "name": "Dorothy",
    "population": 1052570
  },
  {
    "name": "Jessica",
    "population": 1038359
  },
  {
    "name": "Jason",
    "population": 1009416
  },
  {
    "name": "Sarah",
    "population": 1006934
  },
  {
    "name": "Betty",
    "population": 985364
  },
  {
    "name": "Nancy",
    "population": 984185
  },
  {
    "name": "Karen",
    "population": 982192
  },
  {
    "name": "Jeffrey",
    "population": 969093
  },
  {
    "name": "Lisa",
    "population": 962981
  },
  {
    "name": "Ryan",
    "population": 907969
  },
  {
    "name": "Gary",
    "population": 896637
  },
  {
    "name": "Helen",
    "population": 895428
  },
  {
    "name": "Sandra",
    "population": 870958
  },
  {
    "name": "Nicholas",
    "population": 867231
  },
  {
    "name": "Eric",
    "population": 862204
  },
  {
    "name": "Jacob",
    "population": 848518
  },
  {
    "name": "Stephen",
    "population": 844930
  },
  {
    "name": "Ashley",
    "population": 841427
  },
  {
    "name": "Donna",
    "population": 826714
  },
  {
    "name": "Kimberly",
    "population": 826275
  },
  {
    "name": "Frank",
    "population": 818197
  },
  {
    "name": "Carol",
    "population": 817290
  },
  {
    "name": "Jonathan",
    "population": 803723
  },
  {
    "name": "Michelle",
    "population": 803162
  },
  {
    "name": "Larry",
    "population": 801398
  },
  {
    "name": "Emily",
    "population": 779755
  },
  {
    "name": "Amanda",
    "population": 769292
  },
  {
    "name": "Scott",
    "population": 765844
  },
  {
    "name": "Justin",
    "population": 757273
  },
  {
    "name": "Laura",
    "population": 745892
  },
  {
    "name": "Melissa",
    "population": 745498
  },
  {
    "name": "Raymond",
    "population": 744284
  },
  {
    "name": "Deborah",
    "population": 735869
  },
  {
    "name": "Brandon",
    "population": 735849
  },
  {
    "name": "Stephanie",
    "population": 732651
  },
  {
    "name": "Rebecca",
    "population": 728799
  },
  {
    "name": "Ruth",
    "population": 728678
  },
  {
    "name": "Anna",
    "population": 719803
  },
  {
    "name": "Sharon",
    "population": 718701
  },
  {
    "name": "Kathleen",
    "population": 703265
  },
  {
    "name": "Cynthia",
    "population": 703175
  },
  {
    "name": "Gregory",
    "population": 701504
  },
  {
    "name": "Shirley",
    "population": 686079
  },
  {
    "name": "Samuel",
    "population": 681358
  },
  {
    "name": "Amy",
    "population": 673234
  },
  {
    "name": "Benjamin",
    "population": 664328
  },
  {
    "name": "Patrick",
    "population": 655434
  },
  {
    "name": "Angela",
    "population": 653663
  },
  {
    "name": "Jack",
    "population": 634113
  },
  {
    "name": "Virginia",
    "population": 621448
  },
  {
    "name": "Jerry",
    "population": 618105
  },
  {
    "name": "Dennis",
    "population": 610894
  },
  {
    "name": "Catherine",
    "population": 606029
  },
  {
    "name": "Brenda",
    "population": 604067
  },
  {
    "name": "Alexander",
    "population": 598944
  },
  {
    "name": "Katherine",
    "population": 593220
  },
  {
    "name": "Pamela",
    "population": 591307
  },
  {
    "name": "Nicole",
    "population": 576870
  },
  {
    "name": "Tyler",
    "population": 576031
  },
  {
    "name": "Christine",
    "population": 574120
  },
  {
    "name": "Henry",
    "population": 571539
  },
  {
    "name": "Walter",
    "population": 558026
  },
  {
    "name": "Peter",
    "population": 553789
  },
  {
    "name": "Douglas",
    "population": 552666
  },
  {
    "name": "Janet",
    "population": 550557
  }
]
SELECT 
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

malloy compiles to SQL. The SQL query for the above command is.

SELECT
   base.name as name,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc

Expressions

Expressions work much the same as they do in SQL. We can look at population over decade by using a calculation against the year.

query: table('bigquery-public-data.usa_names.usa_1910_2013') -> {
  top: 10
  group_by: decade is floor(`year` / 10) * 10
  aggregate: population is sum(`number`)
}
QUERY RESULTS
decadepopulation
1,95037,545,138
1,96035,405,002
1,99033,309,594
2,00033,041,629
1,98032,349,146
1,97029,238,092
1,94027,776,913
1,92021,375,400
1,93019,782,373
1,91013,592,350
[
  {
    "decade": 1950,
    "population": 37545138
  },
  {
    "decade": 1960,
    "population": 35405002
  },
  {
    "decade": 1990,
    "population": 33309594
  },
  {
    "decade": 2000,
    "population": 33041629
  },
  {
    "decade": 1980,
    "population": 32349146
  },
  {
    "decade": 1970,
    "population": 29238092
  },
  {
    "decade": 1940,
    "population": 27776913
  },
  {
    "decade": 1920,
    "population": 21375400
  },
  {
    "decade": 1930,
    "population": 19782373
  },
  {
    "decade": 1910,
    "population": 13592350
  }
]
SELECT 
   (floor(base.year/10))*10 as decade,
   SUM(base.number) as population
FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
GROUP BY 1
ORDER BY 2 desc
LIMIT 10

Cohorts

source: names is from(
  table('bigquery-public-data.usa_names.usa_1910_2013') -> {
    group_by:
      decade is floor(`year` / 10) * 10
      state
      gender
    aggregate: cohort_population is `number`.sum()
    nest: by_name is {
      group_by: name
      aggregate: population is `number`.sum()
    }
  }
) {
  measure: births_per_100k is floor(by_name.population.sum() / cohort_population.sum() * 100000)
  measure: total_cohort_population is cohort_population.sum()
  dimension: name is concat(by_name.name, '')
}

query: names -> {
  group_by:
    state
    gender
  aggregate: total_cohort_population
  nest: names is {
    where: name  ? 'Michael' | 'Lloyd' | 'Olivia'
    group_by: name
    aggregate: population is by_name.population.sum()
    group_by: births_per_100k
  }
}
QUERY RESULTS
stategendertotal_​cohort_​populationnames
CAM15,011,405
namepopulationbirths_​per_​100k
Michael420,1272,798
Lloyd8,38055
CAF13,799,158
namepopulationbirths_​per_​100k
Olivia33,794244
Michael2,42819
NYM12,203,961
namepopulationbirths_​per_​100k
Michael430,7323,529
Lloyd7,56862
Olivia50
NYF11,490,175
namepopulationbirths_​per_​100k
Olivia23,219202
Michael1,76116
TXM11,126,246
namepopulationbirths_​per_​100k
Michael223,9002,012
Lloyd8,46176
Olivia61
TXF10,341,113
namepopulationbirths_​per_​100k
Olivia25,746248
Michael1,42016
Lloyd151
PAM8,497,961
namepopulationbirths_​per_​100k
Michael266,3803,134
Lloyd7,87492
Olivia222
PAF8,163,949
namepopulationbirths_​per_​100k
Olivia16,292199
Michael91011
ILM7,845,252
namepopulationbirths_​per_​100k
Michael251,7413,208
Lloyd7,20791
ILF7,333,624
namepopulationbirths_​per_​100k
Olivia16,450224
Michael98917
OHM7,324,810
namepopulationbirths_​per_​100k
Michael225,3023,075
Lloyd6,75592
OHF6,876,716
namepopulationbirths_​per_​100k
Olivia16,787244
Michael96918
MIM6,036,661
namepopulationbirths_​per_​100k
Michael194,8513,227
Lloyd6,130101
MIF5,606,794
namepopulationbirths_​per_​100k
Olivia13,575242
Michael75517
FLM4,910,950
namepopulationbirths_​per_​100k
Michael138,8822,828
Lloyd2,87658
FLF4,366,273
namepopulationbirths_​per_​100k
Olivia15,208348
Michael69118
NCM4,326,810
namepopulationbirths_​per_​100k
Michael92,4142,135
Lloyd4,367100
NJM4,315,822
namepopulationbirths_​per_​100k
Michael165,3853,832
Lloyd1,72041
GAM4,214,825
namepopulationbirths_​per_​100k
Michael87,6842,080
Lloyd2,50859
NCF4,113,425
namepopulationbirths_​per_​100k
Olivia10,671259
Michael41619
[
  {
    "state": "CA",
    "gender": "M",
    "total_cohort_population": 15011405,
    "names": [
      {
        "name": "Michael",
        "population": 420127,
        "births_per_100k": 2798
      },
      {
        "name": "Lloyd",
        "population": 8380,
        "births_per_100k": 55
      }
    ]
  },
  {
    "state": "CA",
    "gender": "F",
    "total_cohort_population": 13799158,
    "names": [
      {
        "name": "Olivia",
        "population": 33794,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 2428,
        "births_per_100k": 19
      }
    ]
  },
  {
    "state": "NY",
    "gender": "M",
    "total_cohort_population": 12203961,
    "names": [
      {
        "name": "Michael",
        "population": 430732,
        "births_per_100k": 3529
      },
      {
        "name": "Lloyd",
        "population": 7568,
        "births_per_100k": 62
      },
      {
        "name": "Olivia",
        "population": 5,
        "births_per_100k": 0
      }
    ]
  },
  {
    "state": "NY",
    "gender": "F",
    "total_cohort_population": 11490175,
    "names": [
      {
        "name": "Olivia",
        "population": 23219,
        "births_per_100k": 202
      },
      {
        "name": "Michael",
        "population": 1761,
        "births_per_100k": 16
      }
    ]
  },
  {
    "state": "TX",
    "gender": "M",
    "total_cohort_population": 11126246,
    "names": [
      {
        "name": "Michael",
        "population": 223900,
        "births_per_100k": 2012
      },
      {
        "name": "Lloyd",
        "population": 8461,
        "births_per_100k": 76
      },
      {
        "name": "Olivia",
        "population": 6,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "TX",
    "gender": "F",
    "total_cohort_population": 10341113,
    "names": [
      {
        "name": "Olivia",
        "population": 25746,
        "births_per_100k": 248
      },
      {
        "name": "Michael",
        "population": 1420,
        "births_per_100k": 16
      },
      {
        "name": "Lloyd",
        "population": 15,
        "births_per_100k": 1
      }
    ]
  },
  {
    "state": "PA",
    "gender": "M",
    "total_cohort_population": 8497961,
    "names": [
      {
        "name": "Michael",
        "population": 266380,
        "births_per_100k": 3134
      },
      {
        "name": "Lloyd",
        "population": 7874,
        "births_per_100k": 92
      },
      {
        "name": "Olivia",
        "population": 22,
        "births_per_100k": 2
      }
    ]
  },
  {
    "state": "PA",
    "gender": "F",
    "total_cohort_population": 8163949,
    "names": [
      {
        "name": "Olivia",
        "population": 16292,
        "births_per_100k": 199
      },
      {
        "name": "Michael",
        "population": 910,
        "births_per_100k": 11
      }
    ]
  },
  {
    "state": "IL",
    "gender": "M",
    "total_cohort_population": 7845252,
    "names": [
      {
        "name": "Michael",
        "population": 251741,
        "births_per_100k": 3208
      },
      {
        "name": "Lloyd",
        "population": 7207,
        "births_per_100k": 91
      }
    ]
  },
  {
    "state": "IL",
    "gender": "F",
    "total_cohort_population": 7333624,
    "names": [
      {
        "name": "Olivia",
        "population": 16450,
        "births_per_100k": 224
      },
      {
        "name": "Michael",
        "population": 989,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "OH",
    "gender": "M",
    "total_cohort_population": 7324810,
    "names": [
      {
        "name": "Michael",
        "population": 225302,
        "births_per_100k": 3075
      },
      {
        "name": "Lloyd",
        "population": 6755,
        "births_per_100k": 92
      }
    ]
  },
  {
    "state": "OH",
    "gender": "F",
    "total_cohort_population": 6876716,
    "names": [
      {
        "name": "Olivia",
        "population": 16787,
        "births_per_100k": 244
      },
      {
        "name": "Michael",
        "population": 969,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "MI",
    "gender": "M",
    "total_cohort_population": 6036661,
    "names": [
      {
        "name": "Michael",
        "population": 194851,
        "births_per_100k": 3227
      },
      {
        "name": "Lloyd",
        "population": 6130,
        "births_per_100k": 101
      }
    ]
  },
  {
    "state": "MI",
    "gender": "F",
    "total_cohort_population": 5606794,
    "names": [
      {
        "name": "Olivia",
        "population": 13575,
        "births_per_100k": 242
      },
      {
        "name": "Michael",
        "population": 755,
        "births_per_100k": 17
      }
    ]
  },
  {
    "state": "FL",
    "gender": "M",
    "total_cohort_population": 4910950,
    "names": [
      {
        "name": "Michael",
        "population": 138882,
        "births_per_100k": 2828
      },
      {
        "name": "Lloyd",
        "population": 2876,
        "births_per_100k": 58
      }
    ]
  },
  {
    "state": "FL",
    "gender": "F",
    "total_cohort_population": 4366273,
    "names": [
      {
        "name": "Olivia",
        "population": 15208,
        "births_per_100k": 348
      },
      {
        "name": "Michael",
        "population": 691,
        "births_per_100k": 18
      }
    ]
  },
  {
    "state": "NC",
    "gender": "M",
    "total_cohort_population": 4326810,
    "names": [
      {
        "name": "Michael",
        "population": 92414,
        "births_per_100k": 2135
      },
      {
        "name": "Lloyd",
        "population": 4367,
        "births_per_100k": 100
      }
    ]
  },
  {
    "state": "NJ",
    "gender": "M",
    "total_cohort_population": 4315822,
    "names": [
      {
        "name": "Michael",
        "population": 165385,
        "births_per_100k": 3832
      },
      {
        "name": "Lloyd",
        "population": 1720,
        "births_per_100k": 41
      }
    ]
  },
  {
    "state": "GA",
    "gender": "M",
    "total_cohort_population": 4214825,
    "names": [
      {
        "name": "Michael",
        "population": 87684,
        "births_per_100k": 2080
      },
      {
        "name": "Lloyd",
        "population": 2508,
        "births_per_100k": 59
      }
    ]
  },
  {
    "state": "NC",
    "gender": "F",
    "total_cohort_population": 4113425,
    "names": [
      {
        "name": "Olivia",
        "population": 10671,
        "births_per_100k": 259
      },
      {
        "name": "Michael",
        "population": 416,
        "births_per_100k": 19
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN
      SUM(base.number)
      END as cohort_population__0,
    CASE WHEN group_set=1 THEN
      base.name
      END as name__1,
    CASE WHEN group_set=1 THEN
      SUM(base.number)
      END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_2013` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,6
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
      name__1 as name, 
      population__1 as population
      ) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3
  ORDER BY 4 desc
)
, __stage2 AS (
  SELECT
    group_set,
    names.state as state__0,
    names.gender as gender__0,
    CASE WHEN group_set=0 THEN
      CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64)
      END as total_cohort_population__0,
    CASE WHEN group_set=1 THEN
      concat(by_name_0.name,'')
      END as name__1,
    CASE WHEN group_set=1 THEN
      SUM(by_name_0.population)
      END as population__1,
    CASE WHEN group_set=1 THEN
      floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000)
      END as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names
  LEFT JOIN UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE (group_set NOT IN (1) OR (group_set IN (1) AND ((concat(by_name_0.name,''))='Michael')or(((concat(by_name_0.name,''))='Lloyd')or((concat(by_name_0.name,''))='Olivia'))))
  GROUP BY 1,2,3,5
)
SELECT
  state__0 as state,
  gender__0 as gender,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_cohort_population__0 END) as total_cohort_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
    name__1 as name, 
    population__1 as population, 
    births_per_100k__1 as births_per_100k
    ) END IGNORE NULLS  ORDER BY  population__1 desc ) as names
FROM __stage2
GROUP BY 1,2
ORDER BY 3 desc

Dashboard

query: names -> name_dashboard { where: name ~ 'Mich%' }
QUERY RESULTS
nametotal_​populationstate_​mapdecade_​graph
Michael4,387,274
1,5002,0002,5003,0003,500births_per_100k
1,9201,9401,9601,9802,0002,020decade02,0004,000births_per_100kFemaleMalebaby_gender
Michelle812,865
4006008001,000births_per_100k
1,9201,9401,9601,9802,0002,020decade05001,0001,5002,000births_per_100kFemaleMalebaby_gender
Michele221,803
100200300400births_per_100k
1,9201,9401,9601,9802,0002,020decade0200400births_per_100kFemaleMalebaby_gender
Micheal150,850
50100150200births_per_100k
1,9201,9401,9601,9802,0002,020decade0100200births_per_100kFemaleMalebaby_gender
Michaela48,407
50100150200births_per_100k
1,9401,9601,9802,0002,020decade050100150births_per_100kFemaleMalebaby_gender
Michel7,056
10203040births_per_100k
1,9201,9401,9601,9802,000decade02468births_per_100kFemaleMalebaby_gender
Michell4,377
5101520births_per_100k
1,9601,9802,000decade0510births_per_100kFemaleMalebaby_gender
Michal2,371
02468births_per_100k
1,9401,9601,9802,0002,020decade01020births_per_100kFemaleMalebaby_gender
Michale958
1234births_per_100k
1,9601,9802,000decade0123births_per_100kMalebaby_gender
Michelina903
02468births_per_100k
1,9201,9401,9601,9802,000decade0510births_per_100kFemalebaby_gender
Michaella705
123456births_per_100k
1,9601,9701,9801,9902,0002,010decade01234births_per_100kFemalebaby_gender
Michela616
24681012births_per_100k
1,9401,9601,9802,000decade024births_per_100kFemalebaby_gender
Michaelangelo574
0123births_per_100k
1,9701,9801,9902,0002,0102,020decade0123births_per_100kMalebaby_gender
Michaelene477
01234births_per_100k
1,9301,9401,9501,9601,9701,980decade01234births_per_100kFemalebaby_gender
Michala465
02468births_per_100k
1,9701,9801,9902,000decade024births_per_100kFemalebaby_gender
[
  {
    "name": "Michael",
    "total_population": 4387274,
    "state_map": [
      {
        "state": "RI",
        "births_per_100k": 3702
      },
      {
        "state": "AK",
        "births_per_100k": 3331
      },
      {
        "state": "DE",
        "births_per_100k": 3328
      },
      {
        "state": "VT",
        "births_per_100k": 3049
      },
      {
        "state": "NH",
        "births_per_100k": 2813
      },
      {
        "state": "ME",
        "births_per_100k": 2804
      },
      {
        "state": "WY",
        "births_per_100k": 2667
      },
      {
        "state": "HI",
        "births_per_100k": 2529
      },
      {
        "state": "CT",
        "births_per_100k": 2489
      },
      {
        "state": "NV",
        "births_per_100k": 2443
      },
      {
        "state": "DC",
        "births_per_100k": 2347
      },
      {
        "state": "MT",
        "births_per_100k": 2292
      },
      {
        "state": "MA",
        "births_per_100k": 2240
      },
      {
        "state": "NJ",
        "births_per_100k": 2232
      },
      {
        "state": "SD",
        "births_per_100k": 2228
      },
      {
        "state": "ND",
        "births_per_100k": 1975
      },
      {
        "state": "MD",
        "births_per_100k": 1967
      },
      {
        "state": "ID",
        "births_per_100k": 1964
      },
      {
        "state": "WI",
        "births_per_100k": 1918
      },
      {
        "state": "NE",
        "births_per_100k": 1917
      },
      {
        "state": "OR",
        "births_per_100k": 1873
      },
      {
        "state": "IL",
        "births_per_100k": 1854
      },
      {
        "state": "MI",
        "births_per_100k": 1837
      },
      {
        "state": "NY",
        "births_per_100k": 1817
      },
      {
        "state": "WV",
        "births_per_100k": 1796
      },
      {
        "state": "IA",
        "births_per_100k": 1772
      },
      {
        "state": "OH",
        "births_per_100k": 1763
      },
      {
        "state": "CO",
        "births_per_100k": 1747
      },
      {
        "state": "NM",
        "births_per_100k": 1733
      },
      {
        "state": "MN",
        "births_per_100k": 1701
      },
      {
        "state": "IN",
        "births_per_100k": 1690
      },
      {
        "state": "WA",
        "births_per_100k": 1680
      },
      {
        "state": "MO",
        "births_per_100k": 1659
      },
      {
        "state": "VA",
        "births_per_100k": 1657
      },
      {
        "state": "UT",
        "births_per_100k": 1611
      },
      {
        "state": "AZ",
        "births_per_100k": 1610
      },
      {
        "state": "PA",
        "births_per_100k": 1609
      },
      {
        "state": "KS",
        "births_per_100k": 1604
      },
      {
        "state": "FL",
        "births_per_100k": 1564
      },
      {
        "state": "OK",
        "births_per_100k": 1545
      },
      {
        "state": "LA",
        "births_per_100k": 1433
      },
      {
        "state": "NC",
        "births_per_100k": 1405
      },
      {
        "state": "CA",
        "births_per_100k": 1398
      },
      {
        "state": "AR",
        "births_per_100k": 1385
      },
      {
        "state": "TN",
        "births_per_100k": 1370
      },
      {
        "state": "SC",
        "births_per_100k": 1367
      },
      {
        "state": "KY",
        "births_per_100k": 1348
      },
      {
        "state": "AL",
        "births_per_100k": 1244
      },
      {
        "state": "MS",
        "births_per_100k": 1214
      },
      {
        "state": "GA",
        "births_per_100k": 1144
      },
      {
        "state": "TX",
        "births_per_100k": 1028
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 4562,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 4510,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 4301,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 3848,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 2587,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 2367,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 1409,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 883,
        "baby_gender": "Male"
      },
      {
        "decade": 2020,
        "births_per_100k": 661,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 564,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 501,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 366,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 35,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 32,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 19,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1920,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michelle",
    "total_population": 812865,
    "state_map": [
      {
        "state": "VT",
        "births_per_100k": 1137
      },
      {
        "state": "AK",
        "births_per_100k": 1018
      },
      {
        "state": "HI",
        "births_per_100k": 992
      },
      {
        "state": "WY",
        "births_per_100k": 992
      },
      {
        "state": "DE",
        "births_per_100k": 920
      },
      {
        "state": "RI",
        "births_per_100k": 909
      },
      {
        "state": "ME",
        "births_per_100k": 889
      },
      {
        "state": "NH",
        "births_per_100k": 878
      },
      {
        "state": "NE",
        "births_per_100k": 848
      },
      {
        "state": "SD",
        "births_per_100k": 834
      },
      {
        "state": "ND",
        "births_per_100k": 826
      },
      {
        "state": "NM",
        "births_per_100k": 784
      },
      {
        "state": "CO",
        "births_per_100k": 772
      },
      {
        "state": "NV",
        "births_per_100k": 771
      },
      {
        "state": "MT",
        "births_per_100k": 768
      },
      {
        "state": "IA",
        "births_per_100k": 761
      },
      {
        "state": "KS",
        "births_per_100k": 754
      },
      {
        "state": "CT",
        "births_per_100k": 752
      },
      {
        "state": "OR",
        "births_per_100k": 744
      },
      {
        "state": "UT",
        "births_per_100k": 731
      },
      {
        "state": "DC",
        "births_per_100k": 725
      },
      {
        "state": "WA",
        "births_per_100k": 713
      },
      {
        "state": "ID",
        "births_per_100k": 695
      },
      {
        "state": "AZ",
        "births_per_100k": 694
      },
      {
        "state": "MO",
        "births_per_100k": 665
      },
      {
        "state": "MA",
        "births_per_100k": 652
      },
      {
        "state": "IN",
        "births_per_100k": 611
      },
      {
        "state": "MN",
        "births_per_100k": 593
      },
      {
        "state": "MD",
        "births_per_100k": 583
      },
      {
        "state": "MI",
        "births_per_100k": 563
      },
      {
        "state": "WI",
        "births_per_100k": 531
      },
      {
        "state": "OH",
        "births_per_100k": 524
      },
      {
        "state": "OK",
        "births_per_100k": 507
      },
      {
        "state": "NJ",
        "births_per_100k": 504
      },
      {
        "state": "LA",
        "births_per_100k": 502
      },
      {
        "state": "VA",
        "births_per_100k": 490
      },
      {
        "state": "IL",
        "births_per_100k": 468
      },
      {
        "state": "FL",
        "births_per_100k": 463
      },
      {
        "state": "PA",
        "births_per_100k": 458
      },
      {
        "state": "CA",
        "births_per_100k": 449
      },
      {
        "state": "WV",
        "births_per_100k": 437
      },
      {
        "state": "AR",
        "births_per_100k": 425
      },
      {
        "state": "NY",
        "births_per_100k": 416
      },
      {
        "state": "SC",
        "births_per_100k": 406
      },
      {
        "state": "KY",
        "births_per_100k": 365
      },
      {
        "state": "TN",
        "births_per_100k": 327
      },
      {
        "state": "GA",
        "births_per_100k": 318
      },
      {
        "state": "TX",
        "births_per_100k": 310
      },
      {
        "state": "MS",
        "births_per_100k": 298
      },
      {
        "state": "NC",
        "births_per_100k": 285
      },
      {
        "state": "AL",
        "births_per_100k": 281
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 1814,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1230,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1018,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 559,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 283,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 258,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 120,
        "baby_gender": "Female"
      },
      {
        "decade": 2020,
        "births_per_100k": 74,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 40,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michele",
    "total_population": 221803,
    "state_map": [
      {
        "state": "DE",
        "births_per_100k": 472
      },
      {
        "state": "CT",
        "births_per_100k": 448
      },
      {
        "state": "HI",
        "births_per_100k": 368
      },
      {
        "state": "VT",
        "births_per_100k": 351
      },
      {
        "state": "MD",
        "births_per_100k": 325
      },
      {
        "state": "RI",
        "births_per_100k": 313
      },
      {
        "state": "DC",
        "births_per_100k": 294
      },
      {
        "state": "AK",
        "births_per_100k": 287
      },
      {
        "state": "NH",
        "births_per_100k": 276
      },
      {
        "state": "NJ",
        "births_per_100k": 274
      },
      {
        "state": "SD",
        "births_per_100k": 265
      },
      {
        "state": "NV",
        "births_per_100k": 256
      },
      {
        "state": "MT",
        "births_per_100k": 245
      },
      {
        "state": "WI",
        "births_per_100k": 234
      },
      {
        "state": "ME",
        "births_per_100k": 232
      },
      {
        "state": "IA",
        "births_per_100k": 224
      },
      {
        "state": "NE",
        "births_per_100k": 224
      },
      {
        "state": "WY",
        "births_per_100k": 217
      },
      {
        "state": "ND",
        "births_per_100k": 216
      },
      {
        "state": "PA",
        "births_per_100k": 209
      },
      {
        "state": "MN",
        "births_per_100k": 208
      },
      {
        "state": "UT",
        "births_per_100k": 200
      },
      {
        "state": "MI",
        "births_per_100k": 199
      },
      {
        "state": "IN",
        "births_per_100k": 195
      },
      {
        "state": "OR",
        "births_per_100k": 187
      },
      {
        "state": "MO",
        "births_per_100k": 186
      },
      {
        "state": "MA",
        "births_per_100k": 184
      },
      {
        "state": "WA",
        "births_per_100k": 176
      },
      {
        "state": "ID",
        "births_per_100k": 175
      },
      {
        "state": "OH",
        "births_per_100k": 171
      },
      {
        "state": "KS",
        "births_per_100k": 171
      },
      {
        "state": "CO",
        "births_per_100k": 163
      },
      {
        "state": "NY",
        "births_per_100k": 154
      },
      {
        "state": "WV",
        "births_per_100k": 148
      },
      {
        "state": "IL",
        "births_per_100k": 139
      },
      {
        "state": "NM",
        "births_per_100k": 136
      },
      {
        "state": "VA",
        "births_per_100k": 132
      },
      {
        "state": "AZ",
        "births_per_100k": 116
      },
      {
        "state": "KY",
        "births_per_100k": 112
      },
      {
        "state": "LA",
        "births_per_100k": 112
      },
      {
        "state": "OK",
        "births_per_100k": 106
      },
      {
        "state": "FL",
        "births_per_100k": 99
      },
      {
        "state": "CA",
        "births_per_100k": 95
      },
      {
        "state": "AR",
        "births_per_100k": 87
      },
      {
        "state": "SC",
        "births_per_100k": 73
      },
      {
        "state": "AL",
        "births_per_100k": 68
      },
      {
        "state": "GA",
        "births_per_100k": 64
      },
      {
        "state": "TX",
        "births_per_100k": 57
      },
      {
        "state": "NC",
        "births_per_100k": 55
      },
      {
        "state": "MS",
        "births_per_100k": 51
      },
      {
        "state": "TN",
        "births_per_100k": 47
      }
    ],
    "decade_graph": [
      {
        "decade": 1960,
        "births_per_100k": 513,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 411,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 231,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 113,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 84,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 36,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 2020,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 7,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Micheal",
    "total_population": 150850,
    "state_map": [
      {
        "state": "MS",
        "births_per_100k": 222
      },
      {
        "state": "SD",
        "births_per_100k": 179
      },
      {
        "state": "SC",
        "births_per_100k": 176
      },
      {
        "state": "AR",
        "births_per_100k": 174
      },
      {
        "state": "LA",
        "births_per_100k": 171
      },
      {
        "state": "AL",
        "births_per_100k": 168
      },
      {
        "state": "MT",
        "births_per_100k": 163
      },
      {
        "state": "TN",
        "births_per_100k": 162
      },
      {
        "state": "OK",
        "births_per_100k": 160
      },
      {
        "state": "WY",
        "births_per_100k": 155
      },
      {
        "state": "IA",
        "births_per_100k": 149
      },
      {
        "state": "ID",
        "births_per_100k": 144
      },
      {
        "state": "NC",
        "births_per_100k": 143
      },
      {
        "state": "NM",
        "births_per_100k": 140
      },
      {
        "state": "DC",
        "births_per_100k": 139
      },
      {
        "state": "ND",
        "births_per_100k": 138
      },
      {
        "state": "AK",
        "births_per_100k": 135
      },
      {
        "state": "OR",
        "births_per_100k": 132
      },
      {
        "state": "NE",
        "births_per_100k": 131
      },
      {
        "state": "KY",
        "births_per_100k": 131
      },
      {
        "state": "WV",
        "births_per_100k": 127
      },
      {
        "state": "MO",
        "births_per_100k": 126
      },
      {
        "state": "KS",
        "births_per_100k": 125
      },
      {
        "state": "GA",
        "births_per_100k": 122
      },
      {
        "state": "WA",
        "births_per_100k": 120
      },
      {
        "state": "IN",
        "births_per_100k": 109
      },
      {
        "state": "MI",
        "births_per_100k": 106
      },
      {
        "state": "CO",
        "births_per_100k": 102
      },
      {
        "state": "VA",
        "births_per_100k": 101
      },
      {
        "state": "NV",
        "births_per_100k": 96
      },
      {
        "state": "MD",
        "births_per_100k": 89
      },
      {
        "state": "UT",
        "births_per_100k": 89
      },
      {
        "state": "MN",
        "births_per_100k": 87
      },
      {
        "state": "FL",
        "births_per_100k": 85
      },
      {
        "state": "AZ",
        "births_per_100k": 85
      },
      {
        "state": "WI",
        "births_per_100k": 82
      },
      {
        "state": "IL",
        "births_per_100k": 81
      },
      {
        "state": "ME",
        "births_per_100k": 81
      },
      {
        "state": "VT",
        "births_per_100k": 80
      },
      {
        "state": "OH",
        "births_per_100k": 79
      },
      {
        "state": "TX",
        "births_per_100k": 71
      },
      {
        "state": "NH",
        "births_per_100k": 63
      },
      {
        "state": "DE",
        "births_per_100k": 60
      },
      {
        "state": "CA",
        "births_per_100k": 48
      },
      {
        "state": "PA",
        "births_per_100k": 47
      },
      {
        "state": "CT",
        "births_per_100k": 43
      },
      {
        "state": "RI",
        "births_per_100k": 42
      },
      {
        "state": "NY",
        "births_per_100k": 42
      },
      {
        "state": "NJ",
        "births_per_100k": 41
      },
      {
        "state": "MA",
        "births_per_100k": 38
      },
      {
        "state": "HI",
        "births_per_100k": 32
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 209,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 172,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 152,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 108,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 73,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 71,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 39,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 32,
        "baby_gender": "Male"
      },
      {
        "decade": 1920,
        "births_per_100k": 17,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 16,
        "baby_gender": "Male"
      },
      {
        "decade": 2020,
        "births_per_100k": 13,
        "baby_gender": "Male"
      },
      {
        "decade": 1930,
        "births_per_100k": 12,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaela",
    "total_population": 48407,
    "state_map": [
      {
        "state": "VT",
        "births_per_100k": 229
      },
      {
        "state": "RI",
        "births_per_100k": 209
      },
      {
        "state": "SD",
        "births_per_100k": 178
      },
      {
        "state": "ME",
        "births_per_100k": 162
      },
      {
        "state": "MT",
        "births_per_100k": 160
      },
      {
        "state": "NE",
        "births_per_100k": 148
      },
      {
        "state": "AK",
        "births_per_100k": 115
      },
      {
        "state": "NH",
        "births_per_100k": 115
      },
      {
        "state": "WY",
        "births_per_100k": 110
      },
      {
        "state": "ND",
        "births_per_100k": 102
      },
      {
        "state": "CT",
        "births_per_100k": 96
      },
      {
        "state": "KS",
        "births_per_100k": 94
      },
      {
        "state": "SC",
        "births_per_100k": 94
      },
      {
        "state": "MS",
        "births_per_100k": 93
      },
      {
        "state": "HI",
        "births_per_100k": 92
      },
      {
        "state": "NM",
        "births_per_100k": 91
      },
      {
        "state": "DE",
        "births_per_100k": 89
      },
      {
        "state": "KY",
        "births_per_100k": 89
      },
      {
        "state": "MD",
        "births_per_100k": 86
      },
      {
        "state": "MA",
        "births_per_100k": 84
      },
      {
        "state": "TN",
        "births_per_100k": 83
      },
      {
        "state": "MN",
        "births_per_100k": 82
      },
      {
        "state": "WV",
        "births_per_100k": 79
      },
      {
        "state": "AR",
        "births_per_100k": 78
      },
      {
        "state": "WI",
        "births_per_100k": 77
      },
      {
        "state": "OR",
        "births_per_100k": 73
      },
      {
        "state": "NC",
        "births_per_100k": 73
      },
      {
        "state": "OK",
        "births_per_100k": 73
      },
      {
        "state": "WA",
        "births_per_100k": 73
      },
      {
        "state": "VA",
        "births_per_100k": 71
      },
      {
        "state": "IN",
        "births_per_100k": 70
      },
      {
        "state": "AL",
        "births_per_100k": 68
      },
      {
        "state": "ID",
        "births_per_100k": 68
      },
      {
        "state": "MO",
        "births_per_100k": 67
      },
      {
        "state": "IA",
        "births_per_100k": 65
      },
      {
        "state": "CO",
        "births_per_100k": 64
      },
      {
        "state": "AZ",
        "births_per_100k": 62
      },
      {
        "state": "GA",
        "births_per_100k": 60
      },
      {
        "state": "UT",
        "births_per_100k": 60
      },
      {
        "state": "NV",
        "births_per_100k": 60
      },
      {
        "state": "DC",
        "births_per_100k": 55
      },
      {
        "state": "FL",
        "births_per_100k": 49
      },
      {
        "state": "LA",
        "births_per_100k": 48
      },
      {
        "state": "PA",
        "births_per_100k": 47
      },
      {
        "state": "NJ",
        "births_per_100k": 43
      },
      {
        "state": "OH",
        "births_per_100k": 43
      },
      {
        "state": "IL",
        "births_per_100k": 40
      },
      {
        "state": "MI",
        "births_per_100k": 40
      },
      {
        "state": "TX",
        "births_per_100k": 37
      },
      {
        "state": "NY",
        "births_per_100k": 36
      },
      {
        "state": "CA",
        "births_per_100k": 28
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 149,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 84,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 45,
        "baby_gender": "Female"
      },
      {
        "decade": 2020,
        "births_per_100k": 37,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 27,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michel",
    "total_population": 7056,
    "state_map": [
      {
        "state": "NH",
        "births_per_100k": 46
      },
      {
        "state": "ME",
        "births_per_100k": 30
      },
      {
        "state": "VT",
        "births_per_100k": 12
      },
      {
        "state": "LA",
        "births_per_100k": 11
      },
      {
        "state": "MA",
        "births_per_100k": 8
      },
      {
        "state": "MS",
        "births_per_100k": 8
      },
      {
        "state": "OK",
        "births_per_100k": 7
      },
      {
        "state": "AR",
        "births_per_100k": 7
      },
      {
        "state": "MO",
        "births_per_100k": 7
      },
      {
        "state": "IN",
        "births_per_100k": 7
      },
      {
        "state": "FL",
        "births_per_100k": 6
      },
      {
        "state": "IA",
        "births_per_100k": 6
      },
      {
        "state": "ID",
        "births_per_100k": 6
      },
      {
        "state": "TN",
        "births_per_100k": 5
      },
      {
        "state": "WA",
        "births_per_100k": 5
      },
      {
        "state": "CA",
        "births_per_100k": 5
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "CO",
        "births_per_100k": 5
      },
      {
        "state": "KY",
        "births_per_100k": 5
      },
      {
        "state": "OH",
        "births_per_100k": 4
      },
      {
        "state": "GA",
        "births_per_100k": 4
      },
      {
        "state": "TX",
        "births_per_100k": 4
      },
      {
        "state": "MI",
        "births_per_100k": 4
      },
      {
        "state": "OR",
        "births_per_100k": 4
      },
      {
        "state": "VA",
        "births_per_100k": 4
      },
      {
        "state": "SC",
        "births_per_100k": 4
      },
      {
        "state": "IL",
        "births_per_100k": 3
      },
      {
        "state": "KS",
        "births_per_100k": 3
      },
      {
        "state": "NC",
        "births_per_100k": 3
      },
      {
        "state": "AL",
        "births_per_100k": 3
      },
      {
        "state": "CT",
        "births_per_100k": 3
      },
      {
        "state": "NJ",
        "births_per_100k": 2
      },
      {
        "state": "MN",
        "births_per_100k": 2
      },
      {
        "state": "WI",
        "births_per_100k": 2
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1950,
        "births_per_100k": 9,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 8,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 1940,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1910,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1920,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michell",
    "total_population": 4377,
    "state_map": [
      {
        "state": "MS",
        "births_per_100k": 21
      },
      {
        "state": "LA",
        "births_per_100k": 16
      },
      {
        "state": "MO",
        "births_per_100k": 14
      },
      {
        "state": "AR",
        "births_per_100k": 13
      },
      {
        "state": "CO",
        "births_per_100k": 10
      },
      {
        "state": "NV",
        "births_per_100k": 10
      },
      {
        "state": "GA",
        "births_per_100k": 9
      },
      {
        "state": "OK",
        "births_per_100k": 9
      },
      {
        "state": "KS",
        "births_per_100k": 9
      },
      {
        "state": "IN",
        "births_per_100k": 9
      },
      {
        "state": "AL",
        "births_per_100k": 9
      },
      {
        "state": "KY",
        "births_per_100k": 9
      },
      {
        "state": "SC",
        "births_per_100k": 8
      },
      {
        "state": "DC",
        "births_per_100k": 8
      },
      {
        "state": "AZ",
        "births_per_100k": 7
      },
      {
        "state": "OH",
        "births_per_100k": 6
      },
      {
        "state": "FL",
        "births_per_100k": 6
      },
      {
        "state": "CA",
        "births_per_100k": 6
      },
      {
        "state": "WA",
        "births_per_100k": 6
      },
      {
        "state": "TX",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "IL",
        "births_per_100k": 5
      },
      {
        "state": "MI",
        "births_per_100k": 5
      },
      {
        "state": "MD",
        "births_per_100k": 5
      },
      {
        "state": "NC",
        "births_per_100k": 4
      },
      {
        "state": "NJ",
        "births_per_100k": 4
      },
      {
        "state": "PA",
        "births_per_100k": 4
      },
      {
        "state": "WI",
        "births_per_100k": 4
      },
      {
        "state": "MN",
        "births_per_100k": 3
      },
      {
        "state": "TN",
        "births_per_100k": 3
      },
      {
        "state": "OR",
        "births_per_100k": 3
      },
      {
        "state": "MA",
        "births_per_100k": 2
      },
      {
        "state": "VA",
        "births_per_100k": 2
      },
      {
        "state": "IA",
        "births_per_100k": 2
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 13,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 7,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 6,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 6,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michal",
    "total_population": 2371,
    "state_map": [
      {
        "state": "IL",
        "births_per_100k": 8
      },
      {
        "state": "UT",
        "births_per_100k": 8
      },
      {
        "state": "NJ",
        "births_per_100k": 6
      },
      {
        "state": "NY",
        "births_per_100k": 5
      },
      {
        "state": "CT",
        "births_per_100k": 5
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "CO",
        "births_per_100k": 2
      },
      {
        "state": "IA",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "AL",
        "births_per_100k": 1
      },
      {
        "state": "TN",
        "births_per_100k": 1
      },
      {
        "state": "MO",
        "births_per_100k": 1
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "MA",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 2020,
        "births_per_100k": 22,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 6,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 5,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michale",
    "total_population": 958,
    "state_map": [
      {
        "state": "UT",
        "births_per_100k": 4
      },
      {
        "state": "CA",
        "births_per_100k": 3
      },
      {
        "state": "TX",
        "births_per_100k": 2
      },
      {
        "state": "FL",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "OK",
        "births_per_100k": 2
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "MI",
        "births_per_100k": 1
      },
      {
        "state": "VA",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      },
      {
        "state": "TN",
        "births_per_100k": 1
      },
      {
        "state": "NC",
        "births_per_100k": 1
      },
      {
        "state": "KY",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michelina",
    "total_population": 903,
    "state_map": [
      {
        "state": "RI",
        "births_per_100k": 9
      },
      {
        "state": "CT",
        "births_per_100k": 9
      },
      {
        "state": "MA",
        "births_per_100k": 8
      },
      {
        "state": "NJ",
        "births_per_100k": 7
      },
      {
        "state": "NY",
        "births_per_100k": 6
      },
      {
        "state": "PA",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1920,
        "births_per_100k": 12,
        "baby_gender": "Female"
      },
      {
        "decade": 1910,
        "births_per_100k": 10,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 8,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaella",
    "total_population": 705,
    "state_map": [
      {
        "state": "MA",
        "births_per_100k": 6
      },
      {
        "state": "MO",
        "births_per_100k": 6
      },
      {
        "state": "WA",
        "births_per_100k": 5
      },
      {
        "state": "FL",
        "births_per_100k": 4
      },
      {
        "state": "UT",
        "births_per_100k": 3
      },
      {
        "state": "NC",
        "births_per_100k": 3
      },
      {
        "state": "NY",
        "births_per_100k": 3
      },
      {
        "state": "OH",
        "births_per_100k": 3
      },
      {
        "state": "CO",
        "births_per_100k": 3
      },
      {
        "state": "IN",
        "births_per_100k": 3
      },
      {
        "state": "NJ",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "MI",
        "births_per_100k": 2
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "GA",
        "births_per_100k": 1
      },
      {
        "state": "CA",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michela",
    "total_population": 616,
    "state_map": [
      {
        "state": "MA",
        "births_per_100k": 12
      },
      {
        "state": "NY",
        "births_per_100k": 3
      },
      {
        "state": "NJ",
        "births_per_100k": 3
      },
      {
        "state": "CA",
        "births_per_100k": 2
      },
      {
        "state": "PA",
        "births_per_100k": 2
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 1
      }
    ],
    "decade_graph": [
      {
        "decade": 1990,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 2010,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1940,
        "births_per_100k": 0,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michaelangelo",
    "total_population": 574,
    "state_map": [
      {
        "state": "CA",
        "births_per_100k": 3
      },
      {
        "state": "AZ",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 1
      },
      {
        "state": "TX",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "MA",
        "births_per_100k": 1
      },
      {
        "state": "IL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 2020,
        "births_per_100k": 3,
        "baby_gender": "Male"
      },
      {
        "decade": 2010,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 2000,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1990,
        "births_per_100k": 2,
        "baby_gender": "Male"
      },
      {
        "decade": 1980,
        "births_per_100k": 1,
        "baby_gender": "Male"
      },
      {
        "decade": 1970,
        "births_per_100k": 0,
        "baby_gender": "Male"
      }
    ]
  },
  {
    "name": "Michaelene",
    "total_population": 477,
    "state_map": [
      {
        "state": "IL",
        "births_per_100k": 4
      },
      {
        "state": "PA",
        "births_per_100k": 4
      },
      {
        "state": "IA",
        "births_per_100k": 2
      },
      {
        "state": "MI",
        "births_per_100k": 1
      },
      {
        "state": "OH",
        "births_per_100k": 1
      },
      {
        "state": "NJ",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1940,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1960,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 1950,
        "births_per_100k": 2,
        "baby_gender": "Female"
      },
      {
        "decade": 1930,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1970,
        "births_per_100k": 1,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  },
  {
    "name": "Michala",
    "total_population": 465,
    "state_map": [
      {
        "state": "NC",
        "births_per_100k": 9
      },
      {
        "state": "OK",
        "births_per_100k": 7
      },
      {
        "state": "MO",
        "births_per_100k": 5
      },
      {
        "state": "NE",
        "births_per_100k": 5
      },
      {
        "state": "VA",
        "births_per_100k": 5
      },
      {
        "state": "OH",
        "births_per_100k": 4
      },
      {
        "state": "TX",
        "births_per_100k": 4
      },
      {
        "state": "MI",
        "births_per_100k": 4
      },
      {
        "state": "GA",
        "births_per_100k": 3
      },
      {
        "state": "PA",
        "births_per_100k": 3
      },
      {
        "state": "MD",
        "births_per_100k": 2
      },
      {
        "state": "TN",
        "births_per_100k": 2
      },
      {
        "state": "IL",
        "births_per_100k": 2
      },
      {
        "state": "KY",
        "births_per_100k": 2
      },
      {
        "state": "LA",
        "births_per_100k": 2
      },
      {
        "state": "CA",
        "births_per_100k": 1
      },
      {
        "state": "IN",
        "births_per_100k": 1
      },
      {
        "state": "WA",
        "births_per_100k": 1
      },
      {
        "state": "NY",
        "births_per_100k": 1
      },
      {
        "state": "MN",
        "births_per_100k": 1
      },
      {
        "state": "FL",
        "births_per_100k": 0
      }
    ],
    "decade_graph": [
      {
        "decade": 1970,
        "births_per_100k": 5,
        "baby_gender": "Female"
      },
      {
        "decade": 1980,
        "births_per_100k": 4,
        "baby_gender": "Female"
      },
      {
        "decade": 1990,
        "births_per_100k": 3,
        "baby_gender": "Female"
      },
      {
        "decade": 2000,
        "births_per_100k": 0,
        "baby_gender": "Female"
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN
      SUM(base.number)
      END as cohort_population__0,
    CASE WHEN group_set=1 THEN
      base.name
      END as name__1,
    CASE WHEN group_set=1 THEN
      SUM(base.number)
      END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_current` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,5,7
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    baby_gender__0 as baby_gender,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
      name__1 as name, 
      population__1 as population
      ) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3,4
  ORDER BY 5 desc
)
, __stage2 AS (
  SELECT
    group_set,
    concat(by_name_0.name,'') as name__0,
    CASE WHEN group_set=0 THEN
      SUM(by_name_0.population)
      END as total_population__0,
    CASE WHEN group_set=1 THEN
      names.state
      END as state__1,
    CASE WHEN group_set=1 THEN
      floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000)
      END as births_per_100k__1,
    CASE WHEN group_set=2 THEN
      names.decade
      END as decade__2,
    CASE WHEN group_set=2 THEN
      floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000)
      END as births_per_100k__2,
    CASE WHEN group_set=2 THEN
      names.baby_gender
      END as baby_gender__2
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names
  LEFT JOIN UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE (concat(by_name_0.name,'')) LIKE 'Mich%'
  GROUP BY 1,2,4,6,8
)
SELECT
  name__0 as name,
  ANY_VALUE(CASE WHEN group_set=0 THEN total_population__0 END) as total_population,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
    state__1 as state, 
    births_per_100k__1 as births_per_100k
    ) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as state_map,
  ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(
    decade__2 as decade, 
    births_per_100k__2 as births_per_100k, 
    baby_gender__2 as baby_gender
    ) END IGNORE NULLS  ORDER BY  births_per_100k__2 desc ) as decade_graph
FROM __stage2
GROUP BY 1
ORDER BY 2 desc
LIMIT 15

Iconic Names by State and Gender

Calculate the births per 100K for a name in general and a name within a state. Compute and sort by a ratio to figure out relative popularity.

query: names { where: decade < 1970 } -> {
  group_by: name
  group_by: gender
  aggregate: births_per_100k
  nest: by_state is {
    group_by: state
    aggregate: births_per_100k
  }
} -> {
  where: births_per_100k > 50
  group_by: by_state.state
  nest: by_gender is {
    group_by: gender
    nest: by_name is {
      top: 15
      order_by: popularity desc
      group_by: name
      aggregate: popularity is (by_state.births_per_100k - births_per_100k) / births_per_100k
    }
  }
}
QUERY RESULTS
stateby_​gender
AK
gender
F
by_name
namepopularity
Daisy5.229
Shannon2.506
Lucy2.389
Sophie1.918
Agnes1.852
Tina1.846
Deanna1.841
Katherine1.735
Colleen1.652
Kristin1.567
Leslie1.497
Teresa1.467
Heather1.424
Heidi1.364
Valerie1.361
gender
M
by_name
namepopularity
Shawn3.153
Jason2.708
Troy1.667
Tracy1.623
Sean1.605
Peter1.521
Patrick1.444
Karl1.405
Matthew1.311
Dwayne1.281
Darren1.227
Eric1.206
Mike1.148
Andrew1.14
Micheal1.128
AL
gender
F
by_name
namepopularity
Annie4.751
Willie3.772
Mattie3.689
Johnnie3.338
Rosie3.034
Shelia2.987
Katie2.964
Fannie2.84
Lillie2.705
Essie2.627
Lula2.536
Minnie2.412
Hattie2.318
Mamie2.301
Susie2.299
gender
M
by_name
namepopularity
Willie4.273
Charlie3.119
Roosevelt2.824
Earnest2.691
Jessie2.576
Johnnie2.554
Rickey2.33
Eddie2.284
Jimmie2.24
Horace2.129
Otis2.1
Jimmy2.036
Johnny1.912
Billy1.825
Bennie1.793
AR
gender
F
by_name
namepopularity
Rosie3.23
Bobbie2.79
Erma2.773
Patsy2.558
Billie2.486
Ruby2.28
Velma2.245
Opal2.216
Ollie2.196
Geneva2.163
Willie2.117
Essie1.941
Jessie1.883
Shelia1.848
Lola1.838
gender
M
by_name
namepopularity
Rickey3.636
Billy3.309
Bobby3.242
Jimmy2.891
Jessie2.455
Earnest2.426
Freddie2.321
Tommy2.281
Jimmie2.202
Otis2.15
Jackie2.138
Bennie1.897
Roosevelt1.882
Luther1.821
Cecil1.748
AZ
gender
F
by_name
namepopularity
Carmen5.642
Cecilia3.719
Maria3.649
Lupe3.222
Lydia3.197
Yolanda3
Ramona2.556
Dora1.956
Guadalupe1.911
Susie1.61
Alicia1.606
Veronica1.504
Christina1.492
Rosie1.471
Monica1.394
gender
M
by_name
namepopularity
Manuel8.991
Ruben5.639
Francisco5
Carlos4.418
Jesus4.324
Jose3.604
Gilbert3.48
Antonio3.476
Raul3.145
Alex3.078
Hector2.962
Miguel2.722
Juan2.457
Luis2.365
Woodrow2.058
CA
gender
F
by_name
namepopularity
Christina1.358
Carmen1.347
Yolanda1.257
Teri1.06
Maria1.009
Pat0.907
Cecilia0.877
Leslie0.848
Julie0.837
Victoria0.829
Monica0.78
Ramona0.764
Alicia0.727
Lydia0.724
Shannon0.718
gender
M
by_name
namepopularity
Manuel2.327
Ruben2
Carlos1.468
Mario1.231
Mike1.196
Jason1.069
Bob1.036
Lance0.982
Gilbert0.967
Jim0.965
Dave0.91
Ricardo0.873
Jose0.86
Eric0.829
Chris0.824
CO
gender
F
by_name
namepopularity
Kristi1.962
Shelly1.368
Olive1.269
Bernadette1.211
Ramona1.194
Becky1.101
Nicole1.091
Heather1.071
Della1.053
Heidi1.03
Erma1.015
Dianna1.015
Karla0.968
Kelli0.964
Shannon0.918
gender
M
by_name
namepopularity
Kent1.944
Manuel1.636
Kirk1.606
Woodrow1.558
Gilbert1.374
Kelly1.333
Brett1.288
Bob1.205
Shawn1.119
Delbert1.109
Rick1.104
Mike1.07
Jason1.028
Dave1
Joe0.985
CT
gender
F
by_name
namepopularity
Sophie2.656
Doreen2.646
Claire1.772
Lynn1.664
Gail1.564
Antoinette1.513
Kristen1.509
Maureen1.477
Maryann1.461
Laurie1.408
Marion1.343
Jennie1.258
Heather1.188
Anne1.143
Heidi1.101
gender
M
by_name
namepopularity
Peter2.449
Nicholas1.984
Salvatore1.9
Jonathan1.737
Angelo1.643
Francis1.475
Alexander1.353
Vincent1.269
Marc1.171
Sean1.168
Frederick1.153
Anthony1.022
Louis0.966
Joseph0.908
Theodore0.841
DC
gender
F
by_name
namepopularity
Cassandra2.019
Crystal2.017
Yvette1.867
Tonya1.833
Tanya1.719
Gwendolyn1.559
Leslie1.4
Jacqueline1.365
Delores1.331
Laverne1.327
Renee1.319
Vanessa1.316
Nicole1.291
Monica1.266
Yvonne1.253
gender
M
by_name
namepopularity
Tyrone5.263
Reginald3.785
Derrick2.627
Maurice1.908
Ricardo1.764
Darryl1.693
Dwayne1.688
Derek1.685
Nathaniel1.417
Jonathan1.331
Sean1.261
Eric1.219
Clifton1.167
Bernard1.093
Christopher1
DE
gender
F
by_name
namepopularity
Crystal3.397
Sophie2.869
Mabel2.578
Stella2.339
Hilda2.325
Heather2.129
Elsie2.097
Pearl1.839
Nicole1.836
Agnes1.698
Holly1.589
Kristin1.582
Dawn1.519
Olive1.519
Blanche1.449
gender
M
by_name
namepopularity
Woodrow3.981
Francis2.381
Sean1.479
Matthew1.257
Tyrone1.246
Harry1.212
Roland1.168
Christopher1.167
Franklin1.139
Dwayne1.063
Horace1.048
Willard1.047
Wayne1.04
Bryan1.034
Jonathan0.907
FL
gender
F
by_name
namepopularity
Cassandra1.704
Gwendolyn1.525
Jacquelyn1.323
Rosa1.043
Essie0.98
Belinda0.967
Ernestine0.909
Annie0.866
Iris0.839
Tina0.829
Daisy0.829
Johnnie0.824
Angela0.821
Willie0.772
Inez0.743
gender
M
by_name
namepopularity
Nathaniel2.236
Freddie1.744
Willie1.716
Johnnie1.438
Reginald1.367
Roosevelt1.235
Horace1.177
Eddie1.096
Charlie0.902
Derrick0.896
Jimmie0.845
Johnny0.843
Dwayne0.766
Tyrone0.754
Earnest0.75
GA
gender
F
by_name
namepopularity
Annie3.997
Mattie3.763
Willie3.178
Essie3.098
Mamie3.027
Johnnie2.73
Susie2.494
Fannie2.444
Lillie2.409
Hattie2.282
Katie2.25
Sara2.183
Rosa2.173
Daisy2.071
Lucile2.068
gender
M
by_name
namepopularity
Charlie4.636
Willie4.57
Horace3.081
Otis2.733
Bennie2.483
Johnnie2.438
Eddie2.391
Freddie2.115
Nathaniel2.083
Earnest2.074
Johnny2.044
Marion1.813
Roosevelt1.804
Hugh1.772
Hubert1.769
HI
gender
F
by_name
namepopularity
Kiyoko6.789
Yoshiko6.393
Masako5.984
Fumiko5.911
Mitsue5.868
Shizue4.775
Roxanne4.723
Bernadette4.579
Yoshie4.027
Shizuko3.975
Kikue3.966
Iris3.911
Mitsuko3.888
Violet3.632
Doreen3.415
gender
M
by_name
namepopularity
Toshio7.902
Yoshio7.885
Kiyoshi6.985
Kazuo6.426
Lance6.089
Minoru5.981
Derek5.833
Takeo4.941
Jason4.792
Clayton4.373
Shigeo4.311
Nathan3.968
Guy3.588
Wendell3.208
Sean3.092
IA
gender
F
by_name
namepopularity
Becky1.927
Karla1.921
Maxine1.826
Shelly1.821
Kristi1.577
Julie1.523
Jodi1.443
Sheryl1.403
Marcella1.339
Connie1.327
Tami1.302
Erma1.288
Jody1.269
Kristine1.227
Roxanne1.108
gender
M
by_name
namepopularity
Lyle3.762
Duane2.508
Kent2.113
Dean2.096
Woodrow1.788
Darin1.774
Max1.685
Bradley1.61
Rick1.584
Delbert1.564
Virgil1.487
Dale1.471
Lynn1.45
Jon1.441
Rex1.439
ID
gender
F
by_name
namepopularity
Olive3.808
Karla3.206
Heather2.929
Shannon2.812
Shelley2.73
Kristi2.558
Maxine2.53
Becky2.468
Blanche2.359
Tamara2.342
Robyn2.17
Tami2.159
Jody2.119
Opal2.093
Shelly2.019
gender
M
by_name
namepopularity
Kelly5.944
Brent5.598
Darin5.453
Lynn5.2
Woodrow4.231
Kim3.879
Kent3.775
Lyle3.413
Rex3.368
Max2.973
Tracy2.803
Brett2.493
Brad2.462
Delbert2.4
Rick2.264
IL
gender
F
by_name
namepopularity
Laverne1.273
Dolores0.667
Rosemary0.612
Lorraine0.606
Genevieve0.604
Marcella0.581
Pat0.556
Marianne0.5
Marilyn0.459
Judith0.416
Loretta0.383
Arlene0.37
Eileen0.354
Bernice0.348
Kristine0.33
gender
M
by_name
namepopularity
Jerome0.604
Derrick0.537
Tyrone0.474
Maurice0.429
Bradley0.366
Tom0.336
Lyle0.333
Brad0.295
Chester0.273
Patrick0.264
Kurt0.256
Lawrence0.252
Bob0.25
Martin0.248
Darryl0.248
IN
gender
F
by_name
namepopularity
Tamara1.351
Patty1.193
Tina1.146
Wilma1.017
Penny0.969
Beth0.96
Marsha0.952
Olive0.942
Sue0.937
Lana0.922
Dianna0.912
Becky0.826
Tonya0.822
Marcia0.814
Rebecca0.755
gender
M
by_name
namepopularity
Max2.37
Rex1.93
Kent1.338
Rick1.28
Brent1.134
Bradley1.033
Jeffery0.967
Jeff0.954
Tim0.946
Wilbur0.905
Darrin0.885
Kerry0.879
Darin0.868
Garry0.833
Terry0.754
KS
gender
F
by_name
namepopularity
Karla2.111
Kristi1.923
Maxine1.811
Shelly1.792
Wilma1.73
Opal1.557
Deanna1.449
Connie1.414
Velma1.392
Lana1.373
Lola1.294
Dana1.259
Beulah1.233
Dianna1.221
Sheryl1.202
gender
M
by_name
namepopularity
Darin3.528
Max2.452
Rex2.281
Delbert2.2
Kelly2.167
Virgil2.013
Lyle1.984
Kent1.873
Bradley1.634
Brad1.526
Bob1.375
Brent1.329
Duane1.234
Everett1.231
Marion1.213
KY
gender
F
by_name
namepopularity
Geneva2.827
Della2.07
Opal1.969
Shelia1.797
Wilma1.759
Beulah1.616
Ruby1.472
Wanda1.425
Vickie1.357
Ada1.348
Alma1.273
Nora1.2
Myrtle1.183
Thelma1.103
Eula1.097
gender
M
by_name
namepopularity
Donnie3.343
Jackie2.255
Wendell1.792
Homer1.729
Virgil1.718
Cecil1.687
Ronnie1.646
Bobby1.596
Billy1.596
Hubert1.538
Garry1.5
Everett1.462
Danny1.368
Willard1.365
Luther1.328
LA
gender
F
by_name
namepopularity
Shelia2.582
Irma1.824
Eula1.758
Rosie1.713
Vanessa1.663
Gwendolyn1.619
Mable1.581
Lillie1.43
Hilda1.373
Bobbie1.31
Glenda1.306
Ella1.302
Willie1.284
Cassandra1.241
Paulette1.217
gender
M
by_name
namepopularity
Sidney2.385
Clifton2.25
Freddie2.231
Alvin2.071
Roosevelt1.98
Jessie1.909
Dwayne1.719
Willie1.635
Tyrone1.491
Oliver1.49
Kerry1.466
Herman1.43
Earnest1.412
Calvin1.401
Byron1.358
MA
gender
F
by_name
namepopularity
Claire5.013
Maureen3.052
Priscilla2.288
Lynne1.826
Jeannette1.779
Anne1.585
Joanne1.524
Doreen1.477
Eleanor1.475
Muriel1.418
Sophie1.393
Marion1.295
Eileen1.282
Jeanne1.277
Lorraine1.236
gender
M
by_name
namepopularity
Francis2.843
Peter2.057
Gerard2.014
Dana1.87
Roland1.642
Leo1.503
Frederick1.281
Stephen1.266
Philip1.186
Paul1.179
Jonathan1.144
Alfred1.028
Sean0.966
Arthur0.903
Joseph0.856
MD
gender
F
by_name
namepopularity
Crystal1.638
Hilda1.325
Vanessa1.306
Yvette1.217
Robin1.016
Rosalie0.887
Darlene0.885
Bernadette0.825
Dawn0.814
Terry0.803
Catherine0.803
Tracey0.761
Regina0.75
Naomi0.75
Michele0.749
gender
M
by_name
namepopularity
Tyrone2.07
Dwayne1.484
Roland1.221
Reginald1.127
Clifton1.117
Bernard1.07
Maurice0.969
Franklin0.869
Melvin0.861
Milton0.86
Vernon0.84
Jerome0.832
Harry0.803
Nelson0.732
Darrin0.731
ME
gender
F
by_name
namepopularity
Priscilla4.3
Jeannette3.632
Muriel3.313
Olive2.654
Claire2.506
Constance2.305
Pauline2.265
Madeline2.067
Laurie1.937
Rachel1.85
Debora1.667
Kristen1.623
Marguerite1.621
Heidi1.576
Tina1.529
gender
M
by_name
namepopularity
Dana7.278
Roland6.516
Woodrow4.308
Gerard3.722
Maurice3.633
Clayton2.864
Reginald2.62
Everett2.359
Troy2.141
Philip2.01
Adam1.963
Normand1.852
Marc1.714
Leo1.693
Shawn1.619
MI
gender
F
by_name
namepopularity
Sally0.76
Dawn0.74
Colleen0.652
Sue0.626
Julie0.616
Marcia0.603
Kay0.579
Genevieve0.56
Kelly0.556
Suzanne0.528
Marlene0.513
Michelle0.491
Renee0.488
Sheryl0.476
Shelly0.462
gender
M
by_name
namepopularity
Duane1.065
Gerald0.939
Kim0.862
Gordon0.855
Dave0.836
Lyle0.825
Rick0.784
Darrin0.731
Dale0.692
Fredrick0.673
Kurt0.616
Kirk0.606
Douglas0.556
Dennis0.534
Tim0.514
MN
gender
F
by_name
namepopularity
Jodi2.545
Jody2.06
Marcella2
Kristin1.881
Roxanne1.862
Kristine1.716
Kristi1.712
Colleen1.553
Harriet1.542
Julie1.472
Lorraine1.407
Heidi1.394
Delores1.324
Shelly1.321
Marlene1.256
gender
M
by_name
namepopularity
Lyle3.079
Duane2.919
Bradley2.675
Jerome1.96
Dean1.955
Jason1.889
Darin1.642
Gordon1.62
Todd1.536
Jon1.469
Troy1.43
Dale1.399
Arnold1.366
Allan1.294
Scott1.268
MO
gender
F
by_name
namepopularity
Wilma1.471
Opal1.155
Laverne1.073
Velma0.931
Marcella0.855
Lana0.824
Christy0.804
Beulah0.756
Carla0.745
Shelly0.736
Glenda0.729
Georgia0.726
Norma0.717
Erma0.712
Marsha0.644
gender
M
by_name
namepopularity
Virgil1.397
Darin1.113
Bob1.045
Jackie1.021
Everett0.923
Delbert0.909
Bill0.847
Elmer0.803
Garry0.7
Vernon0.686
Lloyd0.676
Floyd0.673
Oliver0.647
Billy0.641
Marion0.6
MS
gender
F
by_name
namepopularity
Rosie8.402
Annie5.016
Willie4.904
Bobbie4.2
Maggie4.078
Mattie4.052
Katie4.036
Lillie4
Hattie3.988
Essie3.902
Johnnie3.824
Lula3.738
Fannie3.42
Minnie3.176
Jessie3.039
gender
M
by_name
namepopularity
Willie6.282
Roosevelt6.078
Jessie5.535
Johnnie4.339
Eddie3.863
Earnest3.794
Jimmie3.744
Charlie3.734
Bennie3.569
Clifton2.85
Otis2.8
Luther2.373
Sam2.349
Freddie2.192
Johnny1.96
MT
gender
F
by_name
namepopularity
Tami2.683
Mabel2.667
Pat2.593
Jamie2.521
Shelly2.5
Teri2.418
Olive2.385
Karla2.302
Kristi2.192
Patti2.119
Genevieve2.066
Colleen1.929
Shannon1.906
Shelley1.899
Marlene1.776
gender
M
by_name
namepopularity
Kelly3
Lyle2.714
Shawn2.407
Woodrow2.288
Brett2.123
Jason1.972
Brad1.962
Darin1.925
Duane1.887
Darren1.814
Kirk1.761
Dan1.722
Tim1.676
Lance1.625
Rick1.608
NC
gender
F
by_name
namepopularity
Annie3.016
Maggie2.313
Katie2.143
Hattie2.129
Mamie1.973
Sadie1.893
Mable1.71
Lillie1.604
Shelia1.557
Rosa1.554
Fannie1.469
Hilda1.458
Rachel1.425
Crystal1.414
Daisy1.4
gender
M
by_name
namepopularity
Charlie2.713
Clifton2.2
Bobby2.021
Hubert1.969
Luther1.955
Johnnie1.688
Donnie1.687
Horace1.645
Clyde1.424
Claude1.418
Willie1.374
Johnny1.372
Ricky1.286
Jimmy1.258
Marshall1.197
ND
gender
F
by_name
namepopularity
Kristi6.346
Karla5.429
Violet4.057
Myrtle3.603
Shelly3.472
Viola3.297
Roxanne3.277
Jodi3.136
Marlene3.135
Paulette3.043
Olga2.853
Hilda2.831
Olive2.692
Leona2.642
Delores2.615
gender
M
by_name
namepopularity
Lyle6.333
Darin6.132
Troy5.985
Duane5.839
Kelly3.611
Brent3.305
Darren3.206
Bradley3
Lynn2.967
Jason2.819
Arnold2.554
Gordon2.53
Vernon2.526
Kim2.466
Dean2.436
NE
gender
F
by_name
namepopularity
Kristi3.192
Opal2.742
Erma2.197
Maxine2.023
Shelly1.934
Jody1.522
Tami1.492
Jodi1.409
Julie1.408
Olive1.404
Leona1.377
Wilma1.356
Kay1.306
Deanna1.243
Christy1.235
gender
M
by_name
namepopularity
Lyle4.508
Duane2.46
Darin2.377
Kent2.141
Dean1.814
Dale1.805
Bradley1.805
Delbert1.709
Rex1.649
Virgil1.628
Troy1.607
Lynn1.55
Kirk1.493
Rick1.408
Kelly1.403
NH
gender
F
by_name
namepopularity
Kristen6.698
Claire6.203
Jeannette4.912
Priscilla4.863
Heidi3.889
Blanche3.808
Muriel3.612
Olive3.385
Pauline3.313
Nicole2.745
Kristin2.597
Sophie2.508
Stella2.492
Lorraine2.175
Gertrude2.155
gender
M
by_name
namepopularity
Roland7.726
Maurice6.01
Gerard5.139
Dana4.426
Marc3.181
Leo2.687
Normand2.309
Shawn2.153
Jonathan2.136
Peter1.978
Norman1.954
Roger1.828
Jason1.611
Bruce1.494
Scott1.345
NJ
gender
F
by_name
namepopularity
Maryann2.289
Claire1.873
Eileen1.578
Antoinette1.526
Angelina1.462
Rosemarie1.418
Madeline1.28
Maureen1.267
Marianne1.214
Michele1.148
Doreen1.138
Joan1.03
Eleanor0.993
Marion0.971
Sophie0.967
gender
M
by_name
namepopularity
Nicholas2.146
Dominick1.961
Angelo1.911
Vincent1.671
Peter1.492
Alexander1.294
Salvatore1.289
Anthony1.23
Gerard1.167
Joseph1.147
Frank0.95
Louis0.931
Frederick0.803
Edward0.785
Theodore0.785
NM
gender
F
by_name
namepopularity
Cecilia6
Ramona4.694
Carmen4.421
Bernadette3.965
Maria3.782
Lucy3.595
Priscilla3.563
Flora2.969
Yolanda2.771
Dora2.67
Marcella2.645
Lydia2.421
Lupe2.222
Stella2.161
Rosie2.115
gender
M
by_name
namepopularity
Manuel10.227
Jose7.425
Antonio5.476
Gilbert5.228
Ruben5.016
Juan4.843
Carlos4.278
Joe3.835
Pedro2.887
Alex2.766
Luis2.765
Francisco2.75
Miguel2.741
Jesus2.676
Bennie2.517
NV
gender
F
by_name
namepopularity
Olga5.103
Traci4.339
Shannon4.2
Stacey4.148
Pat3.981
Toni3.165
Natalie3.15
Teri3.015
Kelli2.982
Marguerite2.947
Tina2.888
Blanche2.795
Tami2.746
Nicole2.745
Leslie2.673
gender
M
by_name
namepopularity
Jason4.333
Shawn4.178
Troy4.022
Kelly3.736
Woodrow3.654
Lance2.982
Darren2.711
Mike2.526
Brent2
Adam2
Aaron1.986
Darin1.962
Brett1.959
Delbert1.891
Tracy1.639
NY
gender
F
by_name
namepopularity
Antoinette1.756
Eileen1.675
Madeline1.653
Miriam1.618
Muriel1.567
Angelina1.5
Rosemarie1.463
Maureen1.355
Maryann1.158
Marion1
Josephine1
Claire0.987
Anne0.987
Joan0.915
Doreen0.908
gender
M
by_name
namepopularity
Salvatore2.222
Angelo2.054
Dominick2.039
Vincent1.963
Nicholas1.797
Gerard1.792
Peter1.687
Stuart1.21
Anthony1.184
Seymour1.111
Alexander1.035
Martin0.915
Neil0.908
Philip0.89
Louis0.849
OH
gender
F
by_name
namepopularity
Beth0.678
Patty0.651
Sue0.638
Amy0.591
Marcella0.5
Dianna0.456
Becky0.45
Tonya0.433
Kimberly0.422
Rosemary0.412
Marcia0.397
Darla0.397
Penny0.394
Sandy0.392
Marilyn0.39
gender
M
by_name
namepopularity
Rick0.776
Tim0.703
Dave0.687
Dale0.597
Wilbur0.587
Darrin0.519
Jeffrey0.499
Tom0.493
Timothy0.481
Jeffery0.475
Jeff0.424
Ted0.41
Karl0.369
Carl0.356
Dwight0.351
OK
gender
F
by_name
namepopularity
Opal4.134
Billie3.706
Shelly2.396
Velma2.196
Kristi2.192
Patsy2.154
Darla2.138
Wanda2.114
Wilma1.931
Geneva1.786
Lola1.765
Juanita1.704
Erma1.682
Kelli1.655
Ruby1.609
gender
M
by_name
namepopularity
Billy3.137
Jackie2.713
Jimmie2.543
Jimmy2.367
Tommy2.292
Bill2.243
Cecil2.148
Bobby2.11
Delbert2.036
Bob1.964
Virgil1.833
Floyd1.752
Rickey1.67
Don1.535
Ronnie1.472
OR
gender
F
by_name
namepopularity
Tami3.095
Shannon2.647
Shelley1.944
Julie1.912
Kristi1.904
Tamara1.883
Lucile1.695
Shelly1.679
Jan1.557
Becky1.477
Deanna1.449
Kelli1.436
Teri1.433
Karla1.413
Traci1.371
gender
M
by_name
namepopularity
Darin2.981
Woodrow2.75
Kelly2.569
Rick2.16
Jason2.028
Jim1.849
Bob1.786
Dan1.722
Dave1.657
Brad1.603
Delbert1.6
Jeff1.583
Mike1.561
Lyle1.524
Bradley1.512
PA
gender
F
by_name
namepopularity
Anna1.388
Dolores1.13
Maryann1.053
Eleanor0.979
Miriam0.974
Bernadette0.965
Marian0.748
Sophie0.738
Rosemarie0.716
Agnes0.711
Helen0.692
Florence0.687
Stella0.627
Joanne0.622
Marianne0.6
gender
M
by_name
namepopularity
Francis1.395
Harry1.147
Joseph1.013
Nicholas0.919
Barry0.713
Bernard0.668
Vincent0.598
Edward0.595
Andrew0.556
Samuel0.552
Theodore0.528
Alexander0.482
Albert0.463
Stanley0.452
Frank0.441
RI
gender
F
by_name
namepopularity
Claire7.051
Kristen4.245
Muriel4.164
Angelina4
Doreen3.4
Maureen3.221
Jeannette3.015
Madeline2.48
Flora2.313
Jennie2.289
Gertrude2.208
Laurie2.103
Gail2.011
Olga1.956
Sophie1.951
gender
M
by_name
namepopularity
Roland4.263
Gerard3.167
Normand2.901
Angelo2.357
Leo2.307
Marc2.276
Alfred1.968
Peter1.891
Manuel1.818
Raymond1.765
Francis1.642
Maurice1.551
Vincent1.521
Antonio1.476
Anthony1.322
SC
gender
F
by_name
namepopularity
Hattie4.224
Rosa4.094
Maggie3.984
Janie3.949
Annie3.816
Mamie3.753
Daisy3.543
Lillie3.517
Sadie3.125
Carrie3.114
Essie2.804
Lula2.69
Mattie2.63
Willie2.406
Jessie2.266
gender
M
by_name
namepopularity
Marion4.875
Nathaniel4.375
Willie3.948
Roosevelt3.333
Woodrow2.827
Luther2.716
Johnnie2.589
Julius2.571
Leroy2.512
Charlie2.406
Bennie2.345
Freddie2.154
Otis2.133
Horace2.097
Ben1.761
SD
gender
F
by_name
namepopularity
Kristi4.404
Karla3.937
Darla3.362
Tamara2.775
Jody2.612
Violet2.566
Mabel2.559
Kay2.521
Delores2.439
Maxine2.348
Verna2.284
Viola2.281
Olive2.173
Leona2.17
Lana2.078
gender
M
by_name
namepopularity
Lyle7.286
Darin4.962
Kelly4.236
Duane4.089
Bradley3.211
Brad2.628
Troy2.556
Todd2.431
Delbert2.364
Dean2.301
Dale2.231
Elmer1.909
Daryl1.897
Kim1.862
Virgil1.859
TN
gender
F
by_name
namepopularity
Shelia2.772
Bobbie1.82
Wilma1.569
Ruby1.562
Patsy1.538
Billie1.477
Mattie1.452
Glenda1.403
Geneva1.398
Willie1.391
Maggie1.375
Melissa1.251
Wanda1.229
Tonya1.211
Johnnie1.203
gender
M
by_name
namepopularity
Billy2.384
Jackie2.266
Bobby2.217
Rickey2.011
Donnie1.97
Jimmy1.895
Ronnie1.722
Hubert1.6
Luther1.597
Claude1.538
Tommy1.503
Johnny1.482
Ricky1.479
Hugh1.405
Charlie1.28
TX
gender
F
by_name
namepopularity
Maria5.032
Guadalupe2.744
Yolanda2.695
Billie2.495
Irma2.365
Rosa2.338
Alicia2.303
Janie2.179
Dora1.835
Olga1.779
Bobbie1.6
Patsy1.596
Carmen1.589
Lydia1.579
Juanita1.552
gender
M
by_name
namepopularity
Juan5.606
Jose4.903
Ruben4.508
Manuel4.036
Jesus3.765
Pedro3.677
Roberto3.618
Ricardo3.527
Raul3.493
Carlos3.316
Francisco3.309
Antonio3.274
Hector2.528
Guadalupe2.477
Joe2.128
UT
gender
F
by_name
namepopularity
Robyn5.604
Sherrie4.569
Kristine3.341
Erma3.182
Natalie3.167
Becky3.028
Colleen3.014
Jan2.949
Julie2.747
Jody2.373
Heidi2.303
Lucile2.22
Leslie2.176
Teri2.104
Shelly2.094
gender
M
by_name
namepopularity
Brent10.183
Lynn9
Kelly7.111
Kent7.07
Kim5.931
Darin5.528
Woodrow5.365
Brad4.5
Max4.137
Troy4.03
Rex3.93
Tracy3.246
Kerry3.034
Don2.979
Jay2.955
VA
gender
F
by_name
namepopularity
Nannie1.721
Vanessa1.51
Rosa1.331
Shelia1.329
Lucy1.229
Fannie1.062
Elsie1.055
Susie1.052
Thelma0.97
Hattie0.965
Iris0.964
Nellie0.962
Angela0.928
Virginia0.922
Estelle0.909
gender
M
by_name
namepopularity
Charlie1.762
Clifton1.7
Claude1.626
Lewis1.472
Luther1.403
Calvin1.238
Earnest1.191
Otis1.183
Marshall1.115
Cecil1.113
Nelson1.089
Reginald1.051
Franklin1.033
Woodrow1.019
Clarence0.974
VT
gender
F
by_name
namepopularity
Madeline4.8
Marion4.135
Laurie4.013
Blanche3.936
Claire3.481
Olive3
Priscilla2.913
Heather2.835
Heidi2.737
Penny2.276
Marguerite2.274
Pauline2.273
Muriel2.269
Tina2.246
Jeannette2.162
gender
M
by_name
namepopularity
Jason4.139
Reginald3.696
Maurice3.694
Roland3.368
Dana3.315
Wendell2.717
Francis2.635
Bernard2.495
Gordon2.458
Everett2.244
Sean2.151
Shawn2.144
Clayton2
Kim1.793
Todd1.763
WA
gender
F
by_name
namepopularity
Tami2.968
Shannon2.2
Kristi1.788
Heidi1.707
Olive1.673
Shelley1.663
Kelli1.655
Colleen1.645
Kristine1.5
Teri1.388
Pat1.259
Tamara1.234
Gayle1.138
Julie1.133
Deanna1.121
gender
M
by_name
namepopularity
Kelly2.236
Woodrow2.192
Rick2.04
Dave2
Bob1.929
Jim1.849
Dan1.765
Jason1.667
Jeff1.629
Mike1.57
Brad1.372
Gordon1.355
Greg1.355
Bill1.28
Jon1.214
WI
gender
F
by_name
namepopularity
Kristine2.83
Laverne2.455
Jodi1.784
Marcella1.726
Kristin1.328
Lynn1.327
Sophie1.279
Kay1.223
Julie1.157
Jody1.134
Lorraine1.077
Violet1.057
Jill1.034
Arlene1.012
Audrey0.946
gender
M
by_name
namepopularity
Jerome2.107
Lyle2.032
Todd1.807
Duane1.637
Dean1.385
Kurt1.384
Gordon1.217
Dale1.156
Jon1.131
Allan1.129
Gerald1.09
Scott1.078
Arnold0.92
Gregg0.882
Jeffrey0.806
WV
gender
F
by_name
namepopularity
Patty2.241
Opal1.969
Dianna1.779
Beulah1.779
Violet1.774
Mabel1.676
Naomi1.607
Nellie1.481
Della1.386
Tammy1.354
Wilma1.339
Sherri1.151
Nina1.138
Thelma1.122
Maxine1.053
gender
M
by_name
namepopularity
Jackie2.606
Delbert2.2
Homer2.043
Franklin2
Woodrow1.654
Cecil1.652
Virgil1.59
Willard1.424
Everett1.282
Dana1.259
Clyde1.185
Roger1.109
Danny1.036
Luther1.015
Lewis1.007
WY
gender
F
by_name
namepopularity
Pat3.074
Shannon2.894
Becky2.798
Shelley2.551
Natalie2.483
Jody2.418
Jamie2.366
Stacy2.313
Agnes2.289
Shelly2.104
Violet2.094
Olive2
Laurie1.982
Hazel1.974
Opal1.928
gender
M
by_name
namepopularity
Troy5.941
Jason4.431
Kelly3.75
Kim3.552
Brad3.192
Kent2.901
Woodrow2.596
Brett2.548
Lance2.536
Bob2.277
Darin2.038
Jim1.959
Bill1.693
Darren1.67
Bradley1.659
[
  {
    "state": "AK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Daisy",
            "popularity": 5.228571428571429
          },
          {
            "name": "Shannon",
            "popularity": 2.5058823529411764
          },
          {
            "name": "Lucy",
            "popularity": 2.3893129770992365
          },
          {
            "name": "Sophie",
            "popularity": 1.9180327868852458
          },
          {
            "name": "Agnes",
            "popularity": 1.8523489932885906
          },
          {
            "name": "Tina",
            "popularity": 1.8458333333333334
          },
          {
            "name": "Deanna",
            "popularity": 1.841121495327103
          },
          {
            "name": "Katherine",
            "popularity": 1.7352941176470589
          },
          {
            "name": "Colleen",
            "popularity": 1.6524822695035462
          },
          {
            "name": "Kristin",
            "popularity": 1.5671641791044777
          },
          {
            "name": "Leslie",
            "popularity": 1.496969696969697
          },
          {
            "name": "Teresa",
            "popularity": 1.4666666666666666
          },
          {
            "name": "Heather",
            "popularity": 1.423529411764706
          },
          {
            "name": "Heidi",
            "popularity": 1.3636363636363635
          },
          {
            "name": "Valerie",
            "popularity": 1.360655737704918
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Shawn",
            "popularity": 3.152542372881356
          },
          {
            "name": "Jason",
            "popularity": 2.7083333333333335
          },
          {
            "name": "Troy",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Tracy",
            "popularity": 1.6229508196721312
          },
          {
            "name": "Sean",
            "popularity": 1.6050420168067228
          },
          {
            "name": "Peter",
            "popularity": 1.5207877461706782
          },
          {
            "name": "Patrick",
            "popularity": 1.4444444444444444
          },
          {
            "name": "Karl",
            "popularity": 1.4047619047619047
          },
          {
            "name": "Matthew",
            "popularity": 1.3108108108108107
          },
          {
            "name": "Dwayne",
            "popularity": 1.28125
          },
          {
            "name": "Darren",
            "popularity": 1.2268041237113403
          },
          {
            "name": "Eric",
            "popularity": 1.206451612903226
          },
          {
            "name": "Mike",
            "popularity": 1.1478260869565218
          },
          {
            "name": "Andrew",
            "popularity": 1.1396648044692737
          },
          {
            "name": "Micheal",
            "popularity": 1.128
          }
        ]
      }
    ]
  },
  {
    "state": "AL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 4.750778816199377
          },
          {
            "name": "Willie",
            "popularity": 3.771573604060914
          },
          {
            "name": "Mattie",
            "popularity": 3.688888888888889
          },
          {
            "name": "Johnnie",
            "popularity": 3.3378378378378377
          },
          {
            "name": "Rosie",
            "popularity": 3.0344827586206895
          },
          {
            "name": "Shelia",
            "popularity": 2.9873417721518987
          },
          {
            "name": "Katie",
            "popularity": 2.9642857142857144
          },
          {
            "name": "Fannie",
            "popularity": 2.8395061728395063
          },
          {
            "name": "Lillie",
            "popularity": 2.704697986577181
          },
          {
            "name": "Essie",
            "popularity": 2.627450980392157
          },
          {
            "name": "Lula",
            "popularity": 2.5357142857142856
          },
          {
            "name": "Minnie",
            "popularity": 2.4122137404580153
          },
          {
            "name": "Hattie",
            "popularity": 2.3176470588235296
          },
          {
            "name": "Mamie",
            "popularity": 2.3013698630136985
          },
          {
            "name": "Susie",
            "popularity": 2.2987012987012987
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Willie",
            "popularity": 4.27348643006263
          },
          {
            "name": "Charlie",
            "popularity": 3.1188811188811187
          },
          {
            "name": "Roosevelt",
            "popularity": 2.823529411764706
          },
          {
            "name": "Earnest",
            "popularity": 2.6911764705882355
          },
          {
            "name": "Jessie",
            "popularity": 2.5757575757575757
          },
          {
            "name": "Johnnie",
            "popularity": 2.5535714285714284
          },
          {
            "name": "Rickey",
            "popularity": 2.3295454545454546
          },
          {
            "name": "Eddie",
            "popularity": 2.284263959390863
          },
          {
            "name": "Jimmie",
            "popularity": 2.24031007751938
          },
          {
            "name": "Horace",
            "popularity": 2.129032258064516
          },
          {
            "name": "Otis",
            "popularity": 2.1
          },
          {
            "name": "Jimmy",
            "popularity": 2.036363636363636
          },
          {
            "name": "Johnny",
            "popularity": 1.9124087591240877
          },
          {
            "name": "Billy",
            "popularity": 1.825436408977556
          },
          {
            "name": "Bennie",
            "popularity": 1.793103448275862
          }
        ]
      }
    ]
  },
  {
    "state": "AR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosie",
            "popularity": 3.2298850574712645
          },
          {
            "name": "Bobbie",
            "popularity": 2.79
          },
          {
            "name": "Erma",
            "popularity": 2.772727272727273
          },
          {
            "name": "Patsy",
            "popularity": 2.5576923076923075
          },
          {
            "name": "Billie",
            "popularity": 2.4862385321100917
          },
          {
            "name": "Ruby",
            "popularity": 2.279503105590062
          },
          {
            "name": "Velma",
            "popularity": 2.2450980392156863
          },
          {
            "name": "Opal",
            "popularity": 2.216494845360825
          },
          {
            "name": "Ollie",
            "popularity": 2.196078431372549
          },
          {
            "name": "Geneva",
            "popularity": 2.163265306122449
          },
          {
            "name": "Willie",
            "popularity": 2.116751269035533
          },
          {
            "name": "Essie",
            "popularity": 1.9411764705882353
          },
          {
            "name": "Jessie",
            "popularity": 1.8828125
          },
          {
            "name": "Shelia",
            "popularity": 1.8481012658227849
          },
          {
            "name": "Lola",
            "popularity": 1.838235294117647
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Rickey",
            "popularity": 3.6363636363636362
          },
          {
            "name": "Billy",
            "popularity": 3.309226932668329
          },
          {
            "name": "Bobby",
            "popularity": 3.241590214067278
          },
          {
            "name": "Jimmy",
            "popularity": 2.890909090909091
          },
          {
            "name": "Jessie",
            "popularity": 2.4545454545454546
          },
          {
            "name": "Earnest",
            "popularity": 2.426470588235294
          },
          {
            "name": "Freddie",
            "popularity": 2.3205128205128207
          },
          {
            "name": "Tommy",
            "popularity": 2.280701754385965
          },
          {
            "name": "Jimmie",
            "popularity": 2.201550387596899
          },
          {
            "name": "Otis",
            "popularity": 2.15
          },
          {
            "name": "Jackie",
            "popularity": 2.1382978723404253
          },
          {
            "name": "Bennie",
            "popularity": 1.896551724137931
          },
          {
            "name": "Roosevelt",
            "popularity": 1.8823529411764706
          },
          {
            "name": "Luther",
            "popularity": 1.8208955223880596
          },
          {
            "name": "Cecil",
            "popularity": 1.7478260869565216
          }
        ]
      }
    ]
  },
  {
    "state": "AZ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Carmen",
            "popularity": 5.6421052631578945
          },
          {
            "name": "Cecilia",
            "popularity": 3.719298245614035
          },
          {
            "name": "Maria",
            "popularity": 3.6487341772151898
          },
          {
            "name": "Lupe",
            "popularity": 3.2222222222222223
          },
          {
            "name": "Lydia",
            "popularity": 3.1973684210526314
          },
          {
            "name": "Yolanda",
            "popularity": 3
          },
          {
            "name": "Ramona",
            "popularity": 2.5555555555555554
          },
          {
            "name": "Dora",
            "popularity": 1.956043956043956
          },
          {
            "name": "Guadalupe",
            "popularity": 1.9111111111111112
          },
          {
            "name": "Susie",
            "popularity": 1.6103896103896105
          },
          {
            "name": "Alicia",
            "popularity": 1.606060606060606
          },
          {
            "name": "Veronica",
            "popularity": 1.5044247787610618
          },
          {
            "name": "Christina",
            "popularity": 1.4916666666666667
          },
          {
            "name": "Rosie",
            "popularity": 1.471264367816092
          },
          {
            "name": "Monica",
            "popularity": 1.3944954128440368
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 8.99090909090909
          },
          {
            "name": "Ruben",
            "popularity": 5.639344262295082
          },
          {
            "name": "Francisco",
            "popularity": 5
          },
          {
            "name": "Carlos",
            "popularity": 4.417721518987341
          },
          {
            "name": "Jesus",
            "popularity": 4.323529411764706
          },
          {
            "name": "Jose",
            "popularity": 3.603864734299517
          },
          {
            "name": "Gilbert",
            "popularity": 3.4796747967479673
          },
          {
            "name": "Antonio",
            "popularity": 3.4761904761904763
          },
          {
            "name": "Raul",
            "popularity": 3.1449275362318843
          },
          {
            "name": "Alex",
            "popularity": 3.078125
          },
          {
            "name": "Hector",
            "popularity": 2.9622641509433962
          },
          {
            "name": "Miguel",
            "popularity": 2.7222222222222223
          },
          {
            "name": "Juan",
            "popularity": 2.456692913385827
          },
          {
            "name": "Luis",
            "popularity": 2.364705882352941
          },
          {
            "name": "Woodrow",
            "popularity": 2.0576923076923075
          }
        ]
      }
    ]
  },
  {
    "state": "CA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Christina",
            "popularity": 1.3583333333333334
          },
          {
            "name": "Carmen",
            "popularity": 1.3473684210526315
          },
          {
            "name": "Yolanda",
            "popularity": 1.2571428571428571
          },
          {
            "name": "Teri",
            "popularity": 1.0597014925373134
          },
          {
            "name": "Maria",
            "popularity": 1.009493670886076
          },
          {
            "name": "Pat",
            "popularity": 0.9074074074074074
          },
          {
            "name": "Cecilia",
            "popularity": 0.8771929824561403
          },
          {
            "name": "Leslie",
            "popularity": 0.8484848484848485
          },
          {
            "name": "Julie",
            "popularity": 0.8373333333333334
          },
          {
            "name": "Victoria",
            "popularity": 0.8285714285714286
          },
          {
            "name": "Monica",
            "popularity": 0.7798165137614679
          },
          {
            "name": "Ramona",
            "popularity": 0.7638888888888888
          },
          {
            "name": "Alicia",
            "popularity": 0.7272727272727273
          },
          {
            "name": "Lydia",
            "popularity": 0.7236842105263158
          },
          {
            "name": "Shannon",
            "popularity": 0.7176470588235294
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 2.327272727272727
          },
          {
            "name": "Ruben",
            "popularity": 2
          },
          {
            "name": "Carlos",
            "popularity": 1.4683544303797469
          },
          {
            "name": "Mario",
            "popularity": 1.2307692307692308
          },
          {
            "name": "Mike",
            "popularity": 1.1956521739130435
          },
          {
            "name": "Jason",
            "popularity": 1.0694444444444444
          },
          {
            "name": "Bob",
            "popularity": 1.0357142857142858
          },
          {
            "name": "Lance",
            "popularity": 0.9821428571428571
          },
          {
            "name": "Gilbert",
            "popularity": 0.967479674796748
          },
          {
            "name": "Jim",
            "popularity": 0.9651162790697675
          },
          {
            "name": "Dave",
            "popularity": 0.9104477611940298
          },
          {
            "name": "Ricardo",
            "popularity": 0.8727272727272727
          },
          {
            "name": "Jose",
            "popularity": 0.8599033816425121
          },
          {
            "name": "Eric",
            "popularity": 0.8290322580645161
          },
          {
            "name": "Chris",
            "popularity": 0.824
          }
        ]
      }
    ]
  },
  {
    "state": "CO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 1.9615384615384615
          },
          {
            "name": "Shelly",
            "popularity": 1.3679245283018868
          },
          {
            "name": "Olive",
            "popularity": 1.2692307692307692
          },
          {
            "name": "Bernadette",
            "popularity": 1.2105263157894737
          },
          {
            "name": "Ramona",
            "popularity": 1.1944444444444444
          },
          {
            "name": "Becky",
            "popularity": 1.1009174311926606
          },
          {
            "name": "Nicole",
            "popularity": 1.0909090909090908
          },
          {
            "name": "Heather",
            "popularity": 1.0705882352941176
          },
          {
            "name": "Della",
            "popularity": 1.0526315789473684
          },
          {
            "name": "Heidi",
            "popularity": 1.0303030303030303
          },
          {
            "name": "Erma",
            "popularity": 1.0151515151515151
          },
          {
            "name": "Dianna",
            "popularity": 1.0147058823529411
          },
          {
            "name": "Karla",
            "popularity": 0.9682539682539683
          },
          {
            "name": "Kelli",
            "popularity": 0.9636363636363636
          },
          {
            "name": "Shannon",
            "popularity": 0.9176470588235294
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kent",
            "popularity": 1.943661971830986
          },
          {
            "name": "Manuel",
            "popularity": 1.6363636363636365
          },
          {
            "name": "Kirk",
            "popularity": 1.6056338028169015
          },
          {
            "name": "Woodrow",
            "popularity": 1.5576923076923077
          },
          {
            "name": "Gilbert",
            "popularity": 1.3739837398373984
          },
          {
            "name": "Kelly",
            "popularity": 1.3333333333333333
          },
          {
            "name": "Brett",
            "popularity": 1.2876712328767124
          },
          {
            "name": "Bob",
            "popularity": 1.2053571428571428
          },
          {
            "name": "Shawn",
            "popularity": 1.11864406779661
          },
          {
            "name": "Delbert",
            "popularity": 1.1090909090909091
          },
          {
            "name": "Rick",
            "popularity": 1.104
          },
          {
            "name": "Mike",
            "popularity": 1.0695652173913044
          },
          {
            "name": "Jason",
            "popularity": 1.0277777777777777
          },
          {
            "name": "Dave",
            "popularity": 1
          },
          {
            "name": "Joe",
            "popularity": 0.9848484848484849
          }
        ]
      }
    ]
  },
  {
    "state": "CT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Sophie",
            "popularity": 2.6557377049180326
          },
          {
            "name": "Doreen",
            "popularity": 2.646153846153846
          },
          {
            "name": "Claire",
            "popularity": 1.7721518987341771
          },
          {
            "name": "Lynn",
            "popularity": 1.663716814159292
          },
          {
            "name": "Gail",
            "popularity": 1.5643939393939394
          },
          {
            "name": "Antoinette",
            "popularity": 1.5128205128205128
          },
          {
            "name": "Kristen",
            "popularity": 1.509433962264151
          },
          {
            "name": "Maureen",
            "popularity": 1.4767441860465116
          },
          {
            "name": "Maryann",
            "popularity": 1.4605263157894737
          },
          {
            "name": "Laurie",
            "popularity": 1.4080717488789238
          },
          {
            "name": "Marion",
            "popularity": 1.3429951690821256
          },
          {
            "name": "Jennie",
            "popularity": 1.2577319587628866
          },
          {
            "name": "Heather",
            "popularity": 1.188235294117647
          },
          {
            "name": "Anne",
            "popularity": 1.1428571428571428
          },
          {
            "name": "Heidi",
            "popularity": 1.101010101010101
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Peter",
            "popularity": 2.448577680525164
          },
          {
            "name": "Nicholas",
            "popularity": 1.983739837398374
          },
          {
            "name": "Salvatore",
            "popularity": 1.9
          },
          {
            "name": "Jonathan",
            "popularity": 1.7372881355932204
          },
          {
            "name": "Angelo",
            "popularity": 1.6428571428571428
          },
          {
            "name": "Francis",
            "popularity": 1.4749163879598661
          },
          {
            "name": "Alexander",
            "popularity": 1.3529411764705883
          },
          {
            "name": "Vincent",
            "popularity": 1.269406392694064
          },
          {
            "name": "Marc",
            "popularity": 1.1714285714285715
          },
          {
            "name": "Sean",
            "popularity": 1.1680672268907564
          },
          {
            "name": "Frederick",
            "popularity": 1.1526104417670682
          },
          {
            "name": "Anthony",
            "popularity": 1.0221238938053097
          },
          {
            "name": "Louis",
            "popularity": 0.9655172413793104
          },
          {
            "name": "Joseph",
            "popularity": 0.9080841638981174
          },
          {
            "name": "Theodore",
            "popularity": 0.841025641025641
          }
        ]
      }
    ]
  },
  {
    "state": "DC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cassandra",
            "popularity": 2.0185185185185186
          },
          {
            "name": "Crystal",
            "popularity": 2.0172413793103448
          },
          {
            "name": "Yvette",
            "popularity": 1.8666666666666667
          },
          {
            "name": "Tonya",
            "popularity": 1.8333333333333333
          },
          {
            "name": "Tanya",
            "popularity": 1.71875
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.5593220338983051
          },
          {
            "name": "Leslie",
            "popularity": 1.4
          },
          {
            "name": "Jacqueline",
            "popularity": 1.3650793650793651
          },
          {
            "name": "Delores",
            "popularity": 1.3310810810810811
          },
          {
            "name": "Laverne",
            "popularity": 1.3272727272727274
          },
          {
            "name": "Renee",
            "popularity": 1.31875
          },
          {
            "name": "Vanessa",
            "popularity": 1.316326530612245
          },
          {
            "name": "Nicole",
            "popularity": 1.290909090909091
          },
          {
            "name": "Monica",
            "popularity": 1.2660550458715596
          },
          {
            "name": "Yvonne",
            "popularity": 1.2531645569620253
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Tyrone",
            "popularity": 5.2631578947368425
          },
          {
            "name": "Reginald",
            "popularity": 3.7848101265822787
          },
          {
            "name": "Derrick",
            "popularity": 2.626865671641791
          },
          {
            "name": "Maurice",
            "popularity": 1.9081632653061225
          },
          {
            "name": "Ricardo",
            "popularity": 1.7636363636363637
          },
          {
            "name": "Darryl",
            "popularity": 1.693069306930693
          },
          {
            "name": "Dwayne",
            "popularity": 1.6875
          },
          {
            "name": "Derek",
            "popularity": 1.6851851851851851
          },
          {
            "name": "Nathaniel",
            "popularity": 1.4166666666666667
          },
          {
            "name": "Jonathan",
            "popularity": 1.3305084745762712
          },
          {
            "name": "Sean",
            "popularity": 1.2605042016806722
          },
          {
            "name": "Eric",
            "popularity": 1.2193548387096773
          },
          {
            "name": "Clifton",
            "popularity": 1.1666666666666667
          },
          {
            "name": "Bernard",
            "popularity": 1.0934579439252337
          },
          {
            "name": "Christopher",
            "popularity": 1
          }
        ]
      }
    ]
  },
  {
    "state": "DE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Crystal",
            "popularity": 3.396551724137931
          },
          {
            "name": "Sophie",
            "popularity": 2.8688524590163933
          },
          {
            "name": "Mabel",
            "popularity": 2.5784313725490198
          },
          {
            "name": "Stella",
            "popularity": 2.3389830508474576
          },
          {
            "name": "Hilda",
            "popularity": 2.325301204819277
          },
          {
            "name": "Heather",
            "popularity": 2.1294117647058823
          },
          {
            "name": "Elsie",
            "popularity": 2.096969696969697
          },
          {
            "name": "Pearl",
            "popularity": 1.8387096774193548
          },
          {
            "name": "Nicole",
            "popularity": 1.8363636363636364
          },
          {
            "name": "Agnes",
            "popularity": 1.6979865771812082
          },
          {
            "name": "Holly",
            "popularity": 1.588785046728972
          },
          {
            "name": "Kristin",
            "popularity": 1.5820895522388059
          },
          {
            "name": "Dawn",
            "popularity": 1.5193798449612403
          },
          {
            "name": "Olive",
            "popularity": 1.5192307692307692
          },
          {
            "name": "Blanche",
            "popularity": 1.4487179487179487
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Woodrow",
            "popularity": 3.980769230769231
          },
          {
            "name": "Francis",
            "popularity": 2.3812709030100336
          },
          {
            "name": "Sean",
            "popularity": 1.4789915966386555
          },
          {
            "name": "Matthew",
            "popularity": 1.2567567567567568
          },
          {
            "name": "Tyrone",
            "popularity": 1.2456140350877194
          },
          {
            "name": "Harry",
            "popularity": 1.2115384615384615
          },
          {
            "name": "Roland",
            "popularity": 1.168421052631579
          },
          {
            "name": "Christopher",
            "popularity": 1.1674008810572687
          },
          {
            "name": "Franklin",
            "popularity": 1.139344262295082
          },
          {
            "name": "Dwayne",
            "popularity": 1.0625
          },
          {
            "name": "Horace",
            "popularity": 1.0483870967741935
          },
          {
            "name": "Willard",
            "popularity": 1.0470588235294118
          },
          {
            "name": "Wayne",
            "popularity": 1.0395778364116095
          },
          {
            "name": "Bryan",
            "popularity": 1.0341880341880343
          },
          {
            "name": "Jonathan",
            "popularity": 0.9067796610169492
          }
        ]
      }
    ]
  },
  {
    "state": "FL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cassandra",
            "popularity": 1.7037037037037037
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.5254237288135593
          },
          {
            "name": "Jacquelyn",
            "popularity": 1.323076923076923
          },
          {
            "name": "Rosa",
            "popularity": 1.0431654676258992
          },
          {
            "name": "Essie",
            "popularity": 0.9803921568627451
          },
          {
            "name": "Belinda",
            "popularity": 0.967032967032967
          },
          {
            "name": "Ernestine",
            "popularity": 0.9090909090909091
          },
          {
            "name": "Annie",
            "popularity": 0.8660436137071651
          },
          {
            "name": "Iris",
            "popularity": 0.8392857142857143
          },
          {
            "name": "Tina",
            "popularity": 0.8291666666666667
          },
          {
            "name": "Daisy",
            "popularity": 0.8285714285714286
          },
          {
            "name": "Johnnie",
            "popularity": 0.8243243243243243
          },
          {
            "name": "Angela",
            "popularity": 0.8207547169811321
          },
          {
            "name": "Willie",
            "popularity": 0.7715736040609137
          },
          {
            "name": "Inez",
            "popularity": 0.7428571428571429
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nathaniel",
            "popularity": 2.236111111111111
          },
          {
            "name": "Freddie",
            "popularity": 1.7435897435897436
          },
          {
            "name": "Willie",
            "popularity": 1.7160751565762005
          },
          {
            "name": "Johnnie",
            "popularity": 1.4375
          },
          {
            "name": "Reginald",
            "popularity": 1.3670886075949367
          },
          {
            "name": "Roosevelt",
            "popularity": 1.2352941176470589
          },
          {
            "name": "Horace",
            "popularity": 1.1774193548387097
          },
          {
            "name": "Eddie",
            "popularity": 1.0964467005076142
          },
          {
            "name": "Charlie",
            "popularity": 0.9020979020979021
          },
          {
            "name": "Derrick",
            "popularity": 0.8955223880597015
          },
          {
            "name": "Jimmie",
            "popularity": 0.8449612403100775
          },
          {
            "name": "Johnny",
            "popularity": 0.843065693430657
          },
          {
            "name": "Dwayne",
            "popularity": 0.765625
          },
          {
            "name": "Tyrone",
            "popularity": 0.7543859649122807
          },
          {
            "name": "Earnest",
            "popularity": 0.75
          }
        ]
      }
    ]
  },
  {
    "state": "GA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 3.9968847352024923
          },
          {
            "name": "Mattie",
            "popularity": 3.762962962962963
          },
          {
            "name": "Willie",
            "popularity": 3.1776649746192893
          },
          {
            "name": "Essie",
            "popularity": 3.0980392156862746
          },
          {
            "name": "Mamie",
            "popularity": 3.0273972602739727
          },
          {
            "name": "Johnnie",
            "popularity": 2.72972972972973
          },
          {
            "name": "Susie",
            "popularity": 2.4935064935064934
          },
          {
            "name": "Fannie",
            "popularity": 2.4444444444444446
          },
          {
            "name": "Lillie",
            "popularity": 2.4093959731543624
          },
          {
            "name": "Hattie",
            "popularity": 2.2823529411764705
          },
          {
            "name": "Katie",
            "popularity": 2.25
          },
          {
            "name": "Sara",
            "popularity": 2.183006535947712
          },
          {
            "name": "Rosa",
            "popularity": 2.172661870503597
          },
          {
            "name": "Daisy",
            "popularity": 2.0714285714285716
          },
          {
            "name": "Lucile",
            "popularity": 2.0677966101694913
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 4.636363636363637
          },
          {
            "name": "Willie",
            "popularity": 4.569937369519833
          },
          {
            "name": "Horace",
            "popularity": 3.0806451612903225
          },
          {
            "name": "Otis",
            "popularity": 2.7333333333333334
          },
          {
            "name": "Bennie",
            "popularity": 2.4827586206896552
          },
          {
            "name": "Johnnie",
            "popularity": 2.4375
          },
          {
            "name": "Eddie",
            "popularity": 2.3908629441624365
          },
          {
            "name": "Freddie",
            "popularity": 2.1153846153846154
          },
          {
            "name": "Nathaniel",
            "popularity": 2.0833333333333335
          },
          {
            "name": "Earnest",
            "popularity": 2.073529411764706
          },
          {
            "name": "Johnny",
            "popularity": 2.0437956204379564
          },
          {
            "name": "Marion",
            "popularity": 1.8125
          },
          {
            "name": "Roosevelt",
            "popularity": 1.803921568627451
          },
          {
            "name": "Hugh",
            "popularity": 1.7721518987341771
          },
          {
            "name": "Hubert",
            "popularity": 1.7692307692307692
          }
        ]
      }
    ]
  },
  {
    "state": "HI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kiyoko",
            "popularity": 6.7894736842105265
          },
          {
            "name": "Yoshiko",
            "popularity": 6.393258426966292
          },
          {
            "name": "Masako",
            "popularity": 5.983606557377049
          },
          {
            "name": "Fumiko",
            "popularity": 5.910714285714286
          },
          {
            "name": "Mitsue",
            "popularity": 5.867924528301887
          },
          {
            "name": "Shizue",
            "popularity": 4.775280898876405
          },
          {
            "name": "Roxanne",
            "popularity": 4.723076923076923
          },
          {
            "name": "Bernadette",
            "popularity": 4.578947368421052
          },
          {
            "name": "Yoshie",
            "popularity": 4.026666666666666
          },
          {
            "name": "Shizuko",
            "popularity": 3.9753086419753085
          },
          {
            "name": "Kikue",
            "popularity": 3.9655172413793105
          },
          {
            "name": "Iris",
            "popularity": 3.9107142857142856
          },
          {
            "name": "Mitsuko",
            "popularity": 3.8875
          },
          {
            "name": "Violet",
            "popularity": 3.6320754716981134
          },
          {
            "name": "Doreen",
            "popularity": 3.4153846153846152
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Toshio",
            "popularity": 7.901960784313726
          },
          {
            "name": "Yoshio",
            "popularity": 7.884615384615385
          },
          {
            "name": "Kiyoshi",
            "popularity": 6.985074626865671
          },
          {
            "name": "Kazuo",
            "popularity": 6.425925925925926
          },
          {
            "name": "Lance",
            "popularity": 6.089285714285714
          },
          {
            "name": "Minoru",
            "popularity": 5.980769230769231
          },
          {
            "name": "Derek",
            "popularity": 5.833333333333333
          },
          {
            "name": "Takeo",
            "popularity": 4.9411764705882355
          },
          {
            "name": "Jason",
            "popularity": 4.791666666666667
          },
          {
            "name": "Clayton",
            "popularity": 4.372881355932203
          },
          {
            "name": "Shigeo",
            "popularity": 4.311475409836065
          },
          {
            "name": "Nathan",
            "popularity": 3.967741935483871
          },
          {
            "name": "Guy",
            "popularity": 3.588235294117647
          },
          {
            "name": "Wendell",
            "popularity": 3.207547169811321
          },
          {
            "name": "Sean",
            "popularity": 3.092436974789916
          }
        ]
      }
    ]
  },
  {
    "state": "IA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Becky",
            "popularity": 1.926605504587156
          },
          {
            "name": "Karla",
            "popularity": 1.9206349206349207
          },
          {
            "name": "Maxine",
            "popularity": 1.8257575757575757
          },
          {
            "name": "Shelly",
            "popularity": 1.820754716981132
          },
          {
            "name": "Kristi",
            "popularity": 1.5769230769230769
          },
          {
            "name": "Julie",
            "popularity": 1.5226666666666666
          },
          {
            "name": "Jodi",
            "popularity": 1.4431818181818181
          },
          {
            "name": "Sheryl",
            "popularity": 1.403225806451613
          },
          {
            "name": "Marcella",
            "popularity": 1.3387096774193548
          },
          {
            "name": "Connie",
            "popularity": 1.3268608414239482
          },
          {
            "name": "Tami",
            "popularity": 1.3015873015873016
          },
          {
            "name": "Erma",
            "popularity": 1.2878787878787878
          },
          {
            "name": "Jody",
            "popularity": 1.2686567164179106
          },
          {
            "name": "Kristine",
            "popularity": 1.2272727272727273
          },
          {
            "name": "Roxanne",
            "popularity": 1.1076923076923078
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 3.761904761904762
          },
          {
            "name": "Duane",
            "popularity": 2.5080645161290325
          },
          {
            "name": "Kent",
            "popularity": 2.112676056338028
          },
          {
            "name": "Dean",
            "popularity": 2.0961538461538463
          },
          {
            "name": "Woodrow",
            "popularity": 1.7884615384615385
          },
          {
            "name": "Darin",
            "popularity": 1.7735849056603774
          },
          {
            "name": "Max",
            "popularity": 1.6849315068493151
          },
          {
            "name": "Bradley",
            "popularity": 1.6097560975609757
          },
          {
            "name": "Rick",
            "popularity": 1.584
          },
          {
            "name": "Delbert",
            "popularity": 1.5636363636363637
          },
          {
            "name": "Virgil",
            "popularity": 1.4871794871794872
          },
          {
            "name": "Dale",
            "popularity": 1.4707792207792207
          },
          {
            "name": "Lynn",
            "popularity": 1.45
          },
          {
            "name": "Jon",
            "popularity": 1.4413793103448276
          },
          {
            "name": "Rex",
            "popularity": 1.4385964912280702
          }
        ]
      }
    ]
  },
  {
    "state": "ID",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Olive",
            "popularity": 3.8076923076923075
          },
          {
            "name": "Karla",
            "popularity": 3.2063492063492065
          },
          {
            "name": "Heather",
            "popularity": 2.929411764705882
          },
          {
            "name": "Shannon",
            "popularity": 2.8117647058823527
          },
          {
            "name": "Shelley",
            "popularity": 2.730337078651685
          },
          {
            "name": "Kristi",
            "popularity": 2.5576923076923075
          },
          {
            "name": "Maxine",
            "popularity": 2.5303030303030303
          },
          {
            "name": "Becky",
            "popularity": 2.467889908256881
          },
          {
            "name": "Blanche",
            "popularity": 2.358974358974359
          },
          {
            "name": "Tamara",
            "popularity": 2.3423423423423424
          },
          {
            "name": "Robyn",
            "popularity": 2.169811320754717
          },
          {
            "name": "Tami",
            "popularity": 2.1587301587301586
          },
          {
            "name": "Jody",
            "popularity": 2.1194029850746268
          },
          {
            "name": "Opal",
            "popularity": 2.0927835051546393
          },
          {
            "name": "Shelly",
            "popularity": 2.018867924528302
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 5.944444444444445
          },
          {
            "name": "Brent",
            "popularity": 5.597560975609756
          },
          {
            "name": "Darin",
            "popularity": 5.452830188679245
          },
          {
            "name": "Lynn",
            "popularity": 5.2
          },
          {
            "name": "Woodrow",
            "popularity": 4.230769230769231
          },
          {
            "name": "Kim",
            "popularity": 3.8793103448275863
          },
          {
            "name": "Kent",
            "popularity": 3.7746478873239435
          },
          {
            "name": "Lyle",
            "popularity": 3.4126984126984126
          },
          {
            "name": "Rex",
            "popularity": 3.3684210526315788
          },
          {
            "name": "Max",
            "popularity": 2.9726027397260273
          },
          {
            "name": "Tracy",
            "popularity": 2.80327868852459
          },
          {
            "name": "Brett",
            "popularity": 2.493150684931507
          },
          {
            "name": "Brad",
            "popularity": 2.4615384615384617
          },
          {
            "name": "Delbert",
            "popularity": 2.4
          },
          {
            "name": "Rick",
            "popularity": 2.264
          }
        ]
      }
    ]
  },
  {
    "state": "IL",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Laverne",
            "popularity": 1.2727272727272727
          },
          {
            "name": "Dolores",
            "popularity": 0.6666666666666666
          },
          {
            "name": "Rosemary",
            "popularity": 0.611764705882353
          },
          {
            "name": "Lorraine",
            "popularity": 0.6056910569105691
          },
          {
            "name": "Genevieve",
            "popularity": 0.6043956043956044
          },
          {
            "name": "Marcella",
            "popularity": 0.5806451612903226
          },
          {
            "name": "Pat",
            "popularity": 0.5555555555555556
          },
          {
            "name": "Marianne",
            "popularity": 0.5
          },
          {
            "name": "Marilyn",
            "popularity": 0.45879732739420936
          },
          {
            "name": "Judith",
            "popularity": 0.41637010676156583
          },
          {
            "name": "Loretta",
            "popularity": 0.38341968911917096
          },
          {
            "name": "Arlene",
            "popularity": 0.37037037037037035
          },
          {
            "name": "Eileen",
            "popularity": 0.35436893203883496
          },
          {
            "name": "Bernice",
            "popularity": 0.34782608695652173
          },
          {
            "name": "Kristine",
            "popularity": 0.32954545454545453
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jerome",
            "popularity": 0.6040268456375839
          },
          {
            "name": "Derrick",
            "popularity": 0.5373134328358209
          },
          {
            "name": "Tyrone",
            "popularity": 0.47368421052631576
          },
          {
            "name": "Maurice",
            "popularity": 0.42857142857142855
          },
          {
            "name": "Bradley",
            "popularity": 0.36585365853658536
          },
          {
            "name": "Tom",
            "popularity": 0.3355263157894737
          },
          {
            "name": "Lyle",
            "popularity": 0.3333333333333333
          },
          {
            "name": "Brad",
            "popularity": 0.2948717948717949
          },
          {
            "name": "Chester",
            "popularity": 0.2734375
          },
          {
            "name": "Patrick",
            "popularity": 0.26356589147286824
          },
          {
            "name": "Kurt",
            "popularity": 0.2558139534883721
          },
          {
            "name": "Lawrence",
            "popularity": 0.2521186440677966
          },
          {
            "name": "Bob",
            "popularity": 0.25
          },
          {
            "name": "Martin",
            "popularity": 0.24796747967479674
          },
          {
            "name": "Darryl",
            "popularity": 0.24752475247524752
          }
        ]
      }
    ]
  },
  {
    "state": "IN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tamara",
            "popularity": 1.3513513513513513
          },
          {
            "name": "Patty",
            "popularity": 1.1927710843373494
          },
          {
            "name": "Tina",
            "popularity": 1.1458333333333333
          },
          {
            "name": "Wilma",
            "popularity": 1.0172413793103448
          },
          {
            "name": "Penny",
            "popularity": 0.968503937007874
          },
          {
            "name": "Beth",
            "popularity": 0.959731543624161
          },
          {
            "name": "Marsha",
            "popularity": 0.952054794520548
          },
          {
            "name": "Olive",
            "popularity": 0.9423076923076923
          },
          {
            "name": "Sue",
            "popularity": 0.9367816091954023
          },
          {
            "name": "Lana",
            "popularity": 0.9215686274509803
          },
          {
            "name": "Dianna",
            "popularity": 0.9117647058823529
          },
          {
            "name": "Becky",
            "popularity": 0.8256880733944955
          },
          {
            "name": "Tonya",
            "popularity": 0.8222222222222222
          },
          {
            "name": "Marcia",
            "popularity": 0.8141025641025641
          },
          {
            "name": "Rebecca",
            "popularity": 0.7552083333333334
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Max",
            "popularity": 2.3698630136986303
          },
          {
            "name": "Rex",
            "popularity": 1.9298245614035088
          },
          {
            "name": "Kent",
            "popularity": 1.3380281690140845
          },
          {
            "name": "Rick",
            "popularity": 1.28
          },
          {
            "name": "Brent",
            "popularity": 1.1341463414634145
          },
          {
            "name": "Bradley",
            "popularity": 1.032520325203252
          },
          {
            "name": "Jeffery",
            "popularity": 0.9669421487603306
          },
          {
            "name": "Jeff",
            "popularity": 0.9536423841059603
          },
          {
            "name": "Tim",
            "popularity": 0.9459459459459459
          },
          {
            "name": "Wilbur",
            "popularity": 0.9047619047619048
          },
          {
            "name": "Darrin",
            "popularity": 0.8846153846153846
          },
          {
            "name": "Kerry",
            "popularity": 0.8793103448275862
          },
          {
            "name": "Darin",
            "popularity": 0.8679245283018868
          },
          {
            "name": "Garry",
            "popularity": 0.8333333333333334
          },
          {
            "name": "Terry",
            "popularity": 0.7539149888143176
          }
        ]
      }
    ]
  },
  {
    "state": "KS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Karla",
            "popularity": 2.111111111111111
          },
          {
            "name": "Kristi",
            "popularity": 1.9230769230769231
          },
          {
            "name": "Maxine",
            "popularity": 1.8106060606060606
          },
          {
            "name": "Shelly",
            "popularity": 1.7924528301886793
          },
          {
            "name": "Wilma",
            "popularity": 1.7298850574712643
          },
          {
            "name": "Opal",
            "popularity": 1.556701030927835
          },
          {
            "name": "Deanna",
            "popularity": 1.4485981308411215
          },
          {
            "name": "Connie",
            "popularity": 1.4142394822006472
          },
          {
            "name": "Velma",
            "popularity": 1.392156862745098
          },
          {
            "name": "Lana",
            "popularity": 1.3725490196078431
          },
          {
            "name": "Lola",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Dana",
            "popularity": 1.2589285714285714
          },
          {
            "name": "Beulah",
            "popularity": 1.2325581395348837
          },
          {
            "name": "Dianna",
            "popularity": 1.2205882352941178
          },
          {
            "name": "Sheryl",
            "popularity": 1.2016129032258065
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Darin",
            "popularity": 3.5283018867924527
          },
          {
            "name": "Max",
            "popularity": 2.452054794520548
          },
          {
            "name": "Rex",
            "popularity": 2.280701754385965
          },
          {
            "name": "Delbert",
            "popularity": 2.2
          },
          {
            "name": "Kelly",
            "popularity": 2.1666666666666665
          },
          {
            "name": "Virgil",
            "popularity": 2.0128205128205128
          },
          {
            "name": "Lyle",
            "popularity": 1.9841269841269842
          },
          {
            "name": "Kent",
            "popularity": 1.8732394366197183
          },
          {
            "name": "Bradley",
            "popularity": 1.6341463414634145
          },
          {
            "name": "Brad",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Bob",
            "popularity": 1.375
          },
          {
            "name": "Brent",
            "popularity": 1.329268292682927
          },
          {
            "name": "Duane",
            "popularity": 1.2338709677419355
          },
          {
            "name": "Everett",
            "popularity": 1.2307692307692308
          },
          {
            "name": "Marion",
            "popularity": 1.2125
          }
        ]
      }
    ]
  },
  {
    "state": "KY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Geneva",
            "popularity": 2.826530612244898
          },
          {
            "name": "Della",
            "popularity": 2.0701754385964914
          },
          {
            "name": "Opal",
            "popularity": 1.9690721649484537
          },
          {
            "name": "Shelia",
            "popularity": 1.7974683544303798
          },
          {
            "name": "Wilma",
            "popularity": 1.7586206896551724
          },
          {
            "name": "Beulah",
            "popularity": 1.6162790697674418
          },
          {
            "name": "Ruby",
            "popularity": 1.4720496894409938
          },
          {
            "name": "Wanda",
            "popularity": 1.4252199413489737
          },
          {
            "name": "Vickie",
            "popularity": 1.3571428571428572
          },
          {
            "name": "Ada",
            "popularity": 1.3478260869565217
          },
          {
            "name": "Alma",
            "popularity": 1.2733812949640289
          },
          {
            "name": "Nora",
            "popularity": 1.2
          },
          {
            "name": "Myrtle",
            "popularity": 1.1825396825396826
          },
          {
            "name": "Thelma",
            "popularity": 1.102661596958175
          },
          {
            "name": "Eula",
            "popularity": 1.096774193548387
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Donnie",
            "popularity": 3.343283582089552
          },
          {
            "name": "Jackie",
            "popularity": 2.25531914893617
          },
          {
            "name": "Wendell",
            "popularity": 1.7924528301886793
          },
          {
            "name": "Homer",
            "popularity": 1.7285714285714286
          },
          {
            "name": "Virgil",
            "popularity": 1.7179487179487178
          },
          {
            "name": "Cecil",
            "popularity": 1.6869565217391305
          },
          {
            "name": "Ronnie",
            "popularity": 1.6462264150943395
          },
          {
            "name": "Bobby",
            "popularity": 1.5963302752293578
          },
          {
            "name": "Billy",
            "popularity": 1.5960099750623442
          },
          {
            "name": "Hubert",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Garry",
            "popularity": 1.5
          },
          {
            "name": "Everett",
            "popularity": 1.4615384615384615
          },
          {
            "name": "Danny",
            "popularity": 1.3678571428571429
          },
          {
            "name": "Willard",
            "popularity": 1.3647058823529412
          },
          {
            "name": "Luther",
            "popularity": 1.328358208955224
          }
        ]
      }
    ]
  },
  {
    "state": "LA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Shelia",
            "popularity": 2.5822784810126582
          },
          {
            "name": "Irma",
            "popularity": 1.8243243243243243
          },
          {
            "name": "Eula",
            "popularity": 1.7580645161290323
          },
          {
            "name": "Rosie",
            "popularity": 1.7126436781609196
          },
          {
            "name": "Vanessa",
            "popularity": 1.663265306122449
          },
          {
            "name": "Gwendolyn",
            "popularity": 1.61864406779661
          },
          {
            "name": "Mable",
            "popularity": 1.5806451612903225
          },
          {
            "name": "Lillie",
            "popularity": 1.429530201342282
          },
          {
            "name": "Hilda",
            "popularity": 1.3734939759036144
          },
          {
            "name": "Bobbie",
            "popularity": 1.31
          },
          {
            "name": "Glenda",
            "popularity": 1.3055555555555556
          },
          {
            "name": "Ella",
            "popularity": 1.3021582733812949
          },
          {
            "name": "Willie",
            "popularity": 1.284263959390863
          },
          {
            "name": "Cassandra",
            "popularity": 1.2407407407407407
          },
          {
            "name": "Paulette",
            "popularity": 1.2173913043478262
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Sidney",
            "popularity": 2.3846153846153846
          },
          {
            "name": "Clifton",
            "popularity": 2.25
          },
          {
            "name": "Freddie",
            "popularity": 2.230769230769231
          },
          {
            "name": "Alvin",
            "popularity": 2.0714285714285716
          },
          {
            "name": "Roosevelt",
            "popularity": 1.9803921568627452
          },
          {
            "name": "Jessie",
            "popularity": 1.9090909090909092
          },
          {
            "name": "Dwayne",
            "popularity": 1.71875
          },
          {
            "name": "Willie",
            "popularity": 1.6346555323590815
          },
          {
            "name": "Tyrone",
            "popularity": 1.4912280701754386
          },
          {
            "name": "Oliver",
            "popularity": 1.4901960784313726
          },
          {
            "name": "Kerry",
            "popularity": 1.4655172413793103
          },
          {
            "name": "Herman",
            "popularity": 1.4295774647887325
          },
          {
            "name": "Earnest",
            "popularity": 1.411764705882353
          },
          {
            "name": "Calvin",
            "popularity": 1.401360544217687
          },
          {
            "name": "Byron",
            "popularity": 1.3584905660377358
          }
        ]
      }
    ]
  },
  {
    "state": "MA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Claire",
            "popularity": 5.012658227848101
          },
          {
            "name": "Maureen",
            "popularity": 3.052325581395349
          },
          {
            "name": "Priscilla",
            "popularity": 2.2875
          },
          {
            "name": "Lynne",
            "popularity": 1.826086956521739
          },
          {
            "name": "Jeannette",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Anne",
            "popularity": 1.584717607973422
          },
          {
            "name": "Joanne",
            "popularity": 1.5236220472440944
          },
          {
            "name": "Doreen",
            "popularity": 1.476923076923077
          },
          {
            "name": "Eleanor",
            "popularity": 1.475177304964539
          },
          {
            "name": "Muriel",
            "popularity": 1.4179104477611941
          },
          {
            "name": "Sophie",
            "popularity": 1.3934426229508197
          },
          {
            "name": "Marion",
            "popularity": 1.2946859903381642
          },
          {
            "name": "Eileen",
            "popularity": 1.2815533980582525
          },
          {
            "name": "Jeanne",
            "popularity": 1.2774869109947644
          },
          {
            "name": "Lorraine",
            "popularity": 1.2357723577235773
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Francis",
            "popularity": 2.842809364548495
          },
          {
            "name": "Peter",
            "popularity": 2.0568927789934355
          },
          {
            "name": "Gerard",
            "popularity": 2.013888888888889
          },
          {
            "name": "Dana",
            "popularity": 1.8703703703703705
          },
          {
            "name": "Roland",
            "popularity": 1.6421052631578947
          },
          {
            "name": "Leo",
            "popularity": 1.5030674846625767
          },
          {
            "name": "Frederick",
            "popularity": 1.2811244979919678
          },
          {
            "name": "Stephen",
            "popularity": 1.2660550458715596
          },
          {
            "name": "Philip",
            "popularity": 1.186206896551724
          },
          {
            "name": "Paul",
            "popularity": 1.179289026275116
          },
          {
            "name": "Jonathan",
            "popularity": 1.1440677966101696
          },
          {
            "name": "Alfred",
            "popularity": 1.0278884462151394
          },
          {
            "name": "Sean",
            "popularity": 0.9663865546218487
          },
          {
            "name": "Arthur",
            "popularity": 0.9026717557251909
          },
          {
            "name": "Joseph",
            "popularity": 0.8560354374307863
          }
        ]
      }
    ]
  },
  {
    "state": "MD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Crystal",
            "popularity": 1.6379310344827587
          },
          {
            "name": "Hilda",
            "popularity": 1.3253012048192772
          },
          {
            "name": "Vanessa",
            "popularity": 1.3061224489795917
          },
          {
            "name": "Yvette",
            "popularity": 1.2166666666666666
          },
          {
            "name": "Robin",
            "popularity": 1.0163934426229508
          },
          {
            "name": "Rosalie",
            "popularity": 0.8873239436619719
          },
          {
            "name": "Darlene",
            "popularity": 0.8846153846153846
          },
          {
            "name": "Bernadette",
            "popularity": 0.8245614035087719
          },
          {
            "name": "Dawn",
            "popularity": 0.813953488372093
          },
          {
            "name": "Terry",
            "popularity": 0.803030303030303
          },
          {
            "name": "Catherine",
            "popularity": 0.8027923211169284
          },
          {
            "name": "Tracey",
            "popularity": 0.7606837606837606
          },
          {
            "name": "Regina",
            "popularity": 0.75
          },
          {
            "name": "Naomi",
            "popularity": 0.75
          },
          {
            "name": "Michele",
            "popularity": 0.7490774907749077
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Tyrone",
            "popularity": 2.0701754385964914
          },
          {
            "name": "Dwayne",
            "popularity": 1.484375
          },
          {
            "name": "Roland",
            "popularity": 1.2210526315789474
          },
          {
            "name": "Reginald",
            "popularity": 1.1265822784810127
          },
          {
            "name": "Clifton",
            "popularity": 1.1166666666666667
          },
          {
            "name": "Bernard",
            "popularity": 1.0700934579439252
          },
          {
            "name": "Maurice",
            "popularity": 0.9693877551020408
          },
          {
            "name": "Franklin",
            "popularity": 0.8688524590163934
          },
          {
            "name": "Melvin",
            "popularity": 0.8611111111111112
          },
          {
            "name": "Milton",
            "popularity": 0.859504132231405
          },
          {
            "name": "Vernon",
            "popularity": 0.8397435897435898
          },
          {
            "name": "Jerome",
            "popularity": 0.8322147651006712
          },
          {
            "name": "Harry",
            "popularity": 0.8028846153846154
          },
          {
            "name": "Nelson",
            "popularity": 0.7321428571428571
          },
          {
            "name": "Darrin",
            "popularity": 0.7307692307692307
          }
        ]
      }
    ]
  },
  {
    "state": "ME",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Priscilla",
            "popularity": 4.3
          },
          {
            "name": "Jeannette",
            "popularity": 3.6323529411764706
          },
          {
            "name": "Muriel",
            "popularity": 3.3134328358208953
          },
          {
            "name": "Olive",
            "popularity": 2.6538461538461537
          },
          {
            "name": "Claire",
            "popularity": 2.5063291139240507
          },
          {
            "name": "Constance",
            "popularity": 2.3051948051948052
          },
          {
            "name": "Pauline",
            "popularity": 2.2650602409638556
          },
          {
            "name": "Madeline",
            "popularity": 2.066666666666667
          },
          {
            "name": "Laurie",
            "popularity": 1.937219730941704
          },
          {
            "name": "Rachel",
            "popularity": 1.85
          },
          {
            "name": "Debora",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Kristen",
            "popularity": 1.6226415094339623
          },
          {
            "name": "Marguerite",
            "popularity": 1.6210526315789473
          },
          {
            "name": "Heidi",
            "popularity": 1.5757575757575757
          },
          {
            "name": "Tina",
            "popularity": 1.5291666666666666
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Dana",
            "popularity": 7.277777777777778
          },
          {
            "name": "Roland",
            "popularity": 6.515789473684211
          },
          {
            "name": "Woodrow",
            "popularity": 4.3076923076923075
          },
          {
            "name": "Gerard",
            "popularity": 3.7222222222222223
          },
          {
            "name": "Maurice",
            "popularity": 3.63265306122449
          },
          {
            "name": "Clayton",
            "popularity": 2.864406779661017
          },
          {
            "name": "Reginald",
            "popularity": 2.6202531645569622
          },
          {
            "name": "Everett",
            "popularity": 2.358974358974359
          },
          {
            "name": "Troy",
            "popularity": 2.140740740740741
          },
          {
            "name": "Philip",
            "popularity": 2.010344827586207
          },
          {
            "name": "Adam",
            "popularity": 1.962962962962963
          },
          {
            "name": "Normand",
            "popularity": 1.8518518518518519
          },
          {
            "name": "Marc",
            "popularity": 1.7142857142857142
          },
          {
            "name": "Leo",
            "popularity": 1.6932515337423313
          },
          {
            "name": "Shawn",
            "popularity": 1.61864406779661
          }
        ]
      }
    ]
  },
  {
    "state": "MI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Sally",
            "popularity": 0.76
          },
          {
            "name": "Dawn",
            "popularity": 0.7403100775193798
          },
          {
            "name": "Colleen",
            "popularity": 0.6524822695035462
          },
          {
            "name": "Sue",
            "popularity": 0.6264367816091954
          },
          {
            "name": "Julie",
            "popularity": 0.616
          },
          {
            "name": "Marcia",
            "popularity": 0.6025641025641025
          },
          {
            "name": "Kay",
            "popularity": 0.5785123966942148
          },
          {
            "name": "Genevieve",
            "popularity": 0.5604395604395604
          },
          {
            "name": "Kelly",
            "popularity": 0.5564738292011019
          },
          {
            "name": "Suzanne",
            "popularity": 0.5281385281385281
          },
          {
            "name": "Marlene",
            "popularity": 0.5128205128205128
          },
          {
            "name": "Michelle",
            "popularity": 0.4911591355599214
          },
          {
            "name": "Renee",
            "popularity": 0.4875
          },
          {
            "name": "Sheryl",
            "popularity": 0.47580645161290325
          },
          {
            "name": "Shelly",
            "popularity": 0.46226415094339623
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Duane",
            "popularity": 1.064516129032258
          },
          {
            "name": "Gerald",
            "popularity": 0.9387755102040817
          },
          {
            "name": "Kim",
            "popularity": 0.8620689655172413
          },
          {
            "name": "Gordon",
            "popularity": 0.8554216867469879
          },
          {
            "name": "Dave",
            "popularity": 0.835820895522388
          },
          {
            "name": "Lyle",
            "popularity": 0.8253968253968254
          },
          {
            "name": "Rick",
            "popularity": 0.784
          },
          {
            "name": "Darrin",
            "popularity": 0.7307692307692307
          },
          {
            "name": "Dale",
            "popularity": 0.6915584415584416
          },
          {
            "name": "Fredrick",
            "popularity": 0.6730769230769231
          },
          {
            "name": "Kurt",
            "popularity": 0.6162790697674418
          },
          {
            "name": "Kirk",
            "popularity": 0.6056338028169014
          },
          {
            "name": "Douglas",
            "popularity": 0.5559772296015181
          },
          {
            "name": "Dennis",
            "popularity": 0.5336463223787168
          },
          {
            "name": "Tim",
            "popularity": 0.5135135135135135
          }
        ]
      }
    ]
  },
  {
    "state": "MN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Jodi",
            "popularity": 2.5454545454545454
          },
          {
            "name": "Jody",
            "popularity": 2.0597014925373136
          },
          {
            "name": "Marcella",
            "popularity": 2
          },
          {
            "name": "Kristin",
            "popularity": 1.8805970149253732
          },
          {
            "name": "Roxanne",
            "popularity": 1.8615384615384616
          },
          {
            "name": "Kristine",
            "popularity": 1.7159090909090908
          },
          {
            "name": "Kristi",
            "popularity": 1.7115384615384615
          },
          {
            "name": "Colleen",
            "popularity": 1.553191489361702
          },
          {
            "name": "Harriet",
            "popularity": 1.5416666666666667
          },
          {
            "name": "Julie",
            "popularity": 1.472
          },
          {
            "name": "Lorraine",
            "popularity": 1.4065040650406504
          },
          {
            "name": "Heidi",
            "popularity": 1.393939393939394
          },
          {
            "name": "Delores",
            "popularity": 1.3243243243243243
          },
          {
            "name": "Shelly",
            "popularity": 1.320754716981132
          },
          {
            "name": "Marlene",
            "popularity": 1.2564102564102564
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 3.0793650793650795
          },
          {
            "name": "Duane",
            "popularity": 2.9193548387096775
          },
          {
            "name": "Bradley",
            "popularity": 2.6747967479674797
          },
          {
            "name": "Jerome",
            "popularity": 1.9597315436241611
          },
          {
            "name": "Dean",
            "popularity": 1.955128205128205
          },
          {
            "name": "Jason",
            "popularity": 1.8888888888888888
          },
          {
            "name": "Darin",
            "popularity": 1.6415094339622642
          },
          {
            "name": "Gordon",
            "popularity": 1.6204819277108433
          },
          {
            "name": "Todd",
            "popularity": 1.5364963503649636
          },
          {
            "name": "Jon",
            "popularity": 1.4689655172413794
          },
          {
            "name": "Troy",
            "popularity": 1.4296296296296296
          },
          {
            "name": "Dale",
            "popularity": 1.3993506493506493
          },
          {
            "name": "Arnold",
            "popularity": 1.3660714285714286
          },
          {
            "name": "Allan",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Scott",
            "popularity": 1.2675521821631879
          }
        ]
      }
    ]
  },
  {
    "state": "MO",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Wilma",
            "popularity": 1.471264367816092
          },
          {
            "name": "Opal",
            "popularity": 1.1546391752577319
          },
          {
            "name": "Laverne",
            "popularity": 1.0727272727272728
          },
          {
            "name": "Velma",
            "popularity": 0.9313725490196079
          },
          {
            "name": "Marcella",
            "popularity": 0.8548387096774194
          },
          {
            "name": "Lana",
            "popularity": 0.8235294117647058
          },
          {
            "name": "Christy",
            "popularity": 0.803921568627451
          },
          {
            "name": "Beulah",
            "popularity": 0.7558139534883721
          },
          {
            "name": "Carla",
            "popularity": 0.7448275862068966
          },
          {
            "name": "Shelly",
            "popularity": 0.7358490566037735
          },
          {
            "name": "Glenda",
            "popularity": 0.7291666666666666
          },
          {
            "name": "Georgia",
            "popularity": 0.725925925925926
          },
          {
            "name": "Norma",
            "popularity": 0.717391304347826
          },
          {
            "name": "Erma",
            "popularity": 0.7121212121212122
          },
          {
            "name": "Marsha",
            "popularity": 0.6438356164383562
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Virgil",
            "popularity": 1.3974358974358974
          },
          {
            "name": "Darin",
            "popularity": 1.1132075471698113
          },
          {
            "name": "Bob",
            "popularity": 1.0446428571428572
          },
          {
            "name": "Jackie",
            "popularity": 1.0212765957446808
          },
          {
            "name": "Everett",
            "popularity": 0.9230769230769231
          },
          {
            "name": "Delbert",
            "popularity": 0.9090909090909091
          },
          {
            "name": "Bill",
            "popularity": 0.8465608465608465
          },
          {
            "name": "Elmer",
            "popularity": 0.803030303030303
          },
          {
            "name": "Garry",
            "popularity": 0.7
          },
          {
            "name": "Vernon",
            "popularity": 0.6858974358974359
          },
          {
            "name": "Lloyd",
            "popularity": 0.6763005780346821
          },
          {
            "name": "Floyd",
            "popularity": 0.6727272727272727
          },
          {
            "name": "Oliver",
            "popularity": 0.6470588235294118
          },
          {
            "name": "Billy",
            "popularity": 0.6408977556109726
          },
          {
            "name": "Marion",
            "popularity": 0.6
          }
        ]
      }
    ]
  },
  {
    "state": "MS",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Rosie",
            "popularity": 8.402298850574713
          },
          {
            "name": "Annie",
            "popularity": 5.015576323987539
          },
          {
            "name": "Willie",
            "popularity": 4.903553299492386
          },
          {
            "name": "Bobbie",
            "popularity": 4.2
          },
          {
            "name": "Maggie",
            "popularity": 4.078125
          },
          {
            "name": "Mattie",
            "popularity": 4.051851851851852
          },
          {
            "name": "Katie",
            "popularity": 4.035714285714286
          },
          {
            "name": "Lillie",
            "popularity": 4
          },
          {
            "name": "Hattie",
            "popularity": 3.988235294117647
          },
          {
            "name": "Essie",
            "popularity": 3.9019607843137254
          },
          {
            "name": "Johnnie",
            "popularity": 3.824324324324324
          },
          {
            "name": "Lula",
            "popularity": 3.738095238095238
          },
          {
            "name": "Fannie",
            "popularity": 3.419753086419753
          },
          {
            "name": "Minnie",
            "popularity": 3.1755725190839694
          },
          {
            "name": "Jessie",
            "popularity": 3.0390625
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Willie",
            "popularity": 6.281837160751566
          },
          {
            "name": "Roosevelt",
            "popularity": 6.078431372549019
          },
          {
            "name": "Jessie",
            "popularity": 5.5353535353535355
          },
          {
            "name": "Johnnie",
            "popularity": 4.339285714285714
          },
          {
            "name": "Eddie",
            "popularity": 3.8629441624365484
          },
          {
            "name": "Earnest",
            "popularity": 3.7941176470588234
          },
          {
            "name": "Jimmie",
            "popularity": 3.744186046511628
          },
          {
            "name": "Charlie",
            "popularity": 3.734265734265734
          },
          {
            "name": "Bennie",
            "popularity": 3.5689655172413794
          },
          {
            "name": "Clifton",
            "popularity": 2.85
          },
          {
            "name": "Otis",
            "popularity": 2.8
          },
          {
            "name": "Luther",
            "popularity": 2.373134328358209
          },
          {
            "name": "Sam",
            "popularity": 2.349056603773585
          },
          {
            "name": "Freddie",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Johnny",
            "popularity": 1.9598540145985401
          }
        ]
      }
    ]
  },
  {
    "state": "MT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 2.6825396825396823
          },
          {
            "name": "Mabel",
            "popularity": 2.6666666666666665
          },
          {
            "name": "Pat",
            "popularity": 2.5925925925925926
          },
          {
            "name": "Jamie",
            "popularity": 2.5211267605633805
          },
          {
            "name": "Shelly",
            "popularity": 2.5
          },
          {
            "name": "Teri",
            "popularity": 2.417910447761194
          },
          {
            "name": "Olive",
            "popularity": 2.3846153846153846
          },
          {
            "name": "Karla",
            "popularity": 2.3015873015873014
          },
          {
            "name": "Kristi",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Patti",
            "popularity": 2.1194029850746268
          },
          {
            "name": "Genevieve",
            "popularity": 2.065934065934066
          },
          {
            "name": "Colleen",
            "popularity": 1.929078014184397
          },
          {
            "name": "Shannon",
            "popularity": 1.9058823529411764
          },
          {
            "name": "Shelley",
            "popularity": 1.898876404494382
          },
          {
            "name": "Marlene",
            "popularity": 1.7756410256410255
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 3
          },
          {
            "name": "Lyle",
            "popularity": 2.7142857142857144
          },
          {
            "name": "Shawn",
            "popularity": 2.406779661016949
          },
          {
            "name": "Woodrow",
            "popularity": 2.2884615384615383
          },
          {
            "name": "Brett",
            "popularity": 2.1232876712328768
          },
          {
            "name": "Jason",
            "popularity": 1.9722222222222223
          },
          {
            "name": "Brad",
            "popularity": 1.9615384615384615
          },
          {
            "name": "Darin",
            "popularity": 1.9245283018867925
          },
          {
            "name": "Duane",
            "popularity": 1.8870967741935485
          },
          {
            "name": "Darren",
            "popularity": 1.8144329896907216
          },
          {
            "name": "Kirk",
            "popularity": 1.7605633802816902
          },
          {
            "name": "Dan",
            "popularity": 1.7217391304347827
          },
          {
            "name": "Tim",
            "popularity": 1.6756756756756757
          },
          {
            "name": "Lance",
            "popularity": 1.625
          },
          {
            "name": "Rick",
            "popularity": 1.608
          }
        ]
      }
    ]
  },
  {
    "state": "NC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Annie",
            "popularity": 3.015576323987539
          },
          {
            "name": "Maggie",
            "popularity": 2.3125
          },
          {
            "name": "Katie",
            "popularity": 2.142857142857143
          },
          {
            "name": "Hattie",
            "popularity": 2.1294117647058823
          },
          {
            "name": "Mamie",
            "popularity": 1.9726027397260273
          },
          {
            "name": "Sadie",
            "popularity": 1.8928571428571428
          },
          {
            "name": "Mable",
            "popularity": 1.7096774193548387
          },
          {
            "name": "Lillie",
            "popularity": 1.604026845637584
          },
          {
            "name": "Shelia",
            "popularity": 1.5569620253164558
          },
          {
            "name": "Rosa",
            "popularity": 1.5539568345323742
          },
          {
            "name": "Fannie",
            "popularity": 1.4691358024691359
          },
          {
            "name": "Hilda",
            "popularity": 1.4578313253012047
          },
          {
            "name": "Rachel",
            "popularity": 1.425
          },
          {
            "name": "Crystal",
            "popularity": 1.4137931034482758
          },
          {
            "name": "Daisy",
            "popularity": 1.4
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 2.7132867132867133
          },
          {
            "name": "Clifton",
            "popularity": 2.2
          },
          {
            "name": "Bobby",
            "popularity": 2.021406727828746
          },
          {
            "name": "Hubert",
            "popularity": 1.9692307692307693
          },
          {
            "name": "Luther",
            "popularity": 1.955223880597015
          },
          {
            "name": "Johnnie",
            "popularity": 1.6875
          },
          {
            "name": "Donnie",
            "popularity": 1.6865671641791045
          },
          {
            "name": "Horace",
            "popularity": 1.6451612903225807
          },
          {
            "name": "Clyde",
            "popularity": 1.423841059602649
          },
          {
            "name": "Claude",
            "popularity": 1.4175824175824177
          },
          {
            "name": "Willie",
            "popularity": 1.3736951983298538
          },
          {
            "name": "Johnny",
            "popularity": 1.3722627737226278
          },
          {
            "name": "Ricky",
            "popularity": 1.2862068965517242
          },
          {
            "name": "Jimmy",
            "popularity": 1.2581818181818183
          },
          {
            "name": "Marshall",
            "popularity": 1.1967213114754098
          }
        ]
      }
    ]
  },
  {
    "state": "ND",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 6.346153846153846
          },
          {
            "name": "Karla",
            "popularity": 5.428571428571429
          },
          {
            "name": "Violet",
            "popularity": 4.056603773584905
          },
          {
            "name": "Myrtle",
            "popularity": 3.6031746031746033
          },
          {
            "name": "Shelly",
            "popularity": 3.4716981132075473
          },
          {
            "name": "Viola",
            "popularity": 3.296875
          },
          {
            "name": "Roxanne",
            "popularity": 3.276923076923077
          },
          {
            "name": "Jodi",
            "popularity": 3.1363636363636362
          },
          {
            "name": "Marlene",
            "popularity": 3.1346153846153846
          },
          {
            "name": "Paulette",
            "popularity": 3.0434782608695654
          },
          {
            "name": "Olga",
            "popularity": 2.8529411764705883
          },
          {
            "name": "Hilda",
            "popularity": 2.8313253012048194
          },
          {
            "name": "Olive",
            "popularity": 2.6923076923076925
          },
          {
            "name": "Leona",
            "popularity": 2.641509433962264
          },
          {
            "name": "Delores",
            "popularity": 2.614864864864865
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 6.333333333333333
          },
          {
            "name": "Darin",
            "popularity": 6.132075471698113
          },
          {
            "name": "Troy",
            "popularity": 5.985185185185185
          },
          {
            "name": "Duane",
            "popularity": 5.838709677419355
          },
          {
            "name": "Kelly",
            "popularity": 3.611111111111111
          },
          {
            "name": "Brent",
            "popularity": 3.3048780487804876
          },
          {
            "name": "Darren",
            "popularity": 3.2061855670103094
          },
          {
            "name": "Bradley",
            "popularity": 3
          },
          {
            "name": "Lynn",
            "popularity": 2.966666666666667
          },
          {
            "name": "Jason",
            "popularity": 2.8194444444444446
          },
          {
            "name": "Arnold",
            "popularity": 2.5535714285714284
          },
          {
            "name": "Gordon",
            "popularity": 2.5301204819277108
          },
          {
            "name": "Vernon",
            "popularity": 2.5256410256410255
          },
          {
            "name": "Kim",
            "popularity": 2.4655172413793105
          },
          {
            "name": "Dean",
            "popularity": 2.4358974358974357
          }
        ]
      }
    ]
  },
  {
    "state": "NE",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 3.1923076923076925
          },
          {
            "name": "Opal",
            "popularity": 2.7422680412371134
          },
          {
            "name": "Erma",
            "popularity": 2.196969696969697
          },
          {
            "name": "Maxine",
            "popularity": 2.022727272727273
          },
          {
            "name": "Shelly",
            "popularity": 1.9339622641509433
          },
          {
            "name": "Jody",
            "popularity": 1.5223880597014925
          },
          {
            "name": "Tami",
            "popularity": 1.492063492063492
          },
          {
            "name": "Jodi",
            "popularity": 1.4090909090909092
          },
          {
            "name": "Julie",
            "popularity": 1.408
          },
          {
            "name": "Olive",
            "popularity": 1.4038461538461537
          },
          {
            "name": "Leona",
            "popularity": 1.3773584905660377
          },
          {
            "name": "Wilma",
            "popularity": 1.3563218390804597
          },
          {
            "name": "Kay",
            "popularity": 1.3057851239669422
          },
          {
            "name": "Deanna",
            "popularity": 1.2429906542056075
          },
          {
            "name": "Christy",
            "popularity": 1.2352941176470589
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 4.507936507936508
          },
          {
            "name": "Duane",
            "popularity": 2.4596774193548385
          },
          {
            "name": "Darin",
            "popularity": 2.3773584905660377
          },
          {
            "name": "Kent",
            "popularity": 2.140845070422535
          },
          {
            "name": "Dean",
            "popularity": 1.814102564102564
          },
          {
            "name": "Dale",
            "popularity": 1.8051948051948052
          },
          {
            "name": "Bradley",
            "popularity": 1.8048780487804879
          },
          {
            "name": "Delbert",
            "popularity": 1.709090909090909
          },
          {
            "name": "Rex",
            "popularity": 1.6491228070175439
          },
          {
            "name": "Virgil",
            "popularity": 1.6282051282051282
          },
          {
            "name": "Troy",
            "popularity": 1.6074074074074074
          },
          {
            "name": "Lynn",
            "popularity": 1.55
          },
          {
            "name": "Kirk",
            "popularity": 1.4929577464788732
          },
          {
            "name": "Rick",
            "popularity": 1.408
          },
          {
            "name": "Kelly",
            "popularity": 1.4027777777777777
          }
        ]
      }
    ]
  },
  {
    "state": "NH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristen",
            "popularity": 6.69811320754717
          },
          {
            "name": "Claire",
            "popularity": 6.2025316455696204
          },
          {
            "name": "Jeannette",
            "popularity": 4.911764705882353
          },
          {
            "name": "Priscilla",
            "popularity": 4.8625
          },
          {
            "name": "Heidi",
            "popularity": 3.888888888888889
          },
          {
            "name": "Blanche",
            "popularity": 3.8076923076923075
          },
          {
            "name": "Muriel",
            "popularity": 3.611940298507463
          },
          {
            "name": "Olive",
            "popularity": 3.3846153846153846
          },
          {
            "name": "Pauline",
            "popularity": 3.3132530120481927
          },
          {
            "name": "Nicole",
            "popularity": 2.7454545454545456
          },
          {
            "name": "Kristin",
            "popularity": 2.5970149253731343
          },
          {
            "name": "Sophie",
            "popularity": 2.5081967213114753
          },
          {
            "name": "Stella",
            "popularity": 2.4915254237288136
          },
          {
            "name": "Lorraine",
            "popularity": 2.1747967479674797
          },
          {
            "name": "Gertrude",
            "popularity": 2.1547619047619047
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Roland",
            "popularity": 7.726315789473684
          },
          {
            "name": "Maurice",
            "popularity": 6.010204081632653
          },
          {
            "name": "Gerard",
            "popularity": 5.138888888888889
          },
          {
            "name": "Dana",
            "popularity": 4.425925925925926
          },
          {
            "name": "Marc",
            "popularity": 3.1809523809523808
          },
          {
            "name": "Leo",
            "popularity": 2.687116564417178
          },
          {
            "name": "Normand",
            "popularity": 2.308641975308642
          },
          {
            "name": "Shawn",
            "popularity": 2.152542372881356
          },
          {
            "name": "Jonathan",
            "popularity": 2.135593220338983
          },
          {
            "name": "Peter",
            "popularity": 1.9781181619256019
          },
          {
            "name": "Norman",
            "popularity": 1.9540636042402826
          },
          {
            "name": "Roger",
            "popularity": 1.827659574468085
          },
          {
            "name": "Jason",
            "popularity": 1.6111111111111112
          },
          {
            "name": "Bruce",
            "popularity": 1.4939759036144578
          },
          {
            "name": "Scott",
            "popularity": 1.3453510436432639
          }
        ]
      }
    ]
  },
  {
    "state": "NJ",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maryann",
            "popularity": 2.289473684210526
          },
          {
            "name": "Claire",
            "popularity": 1.8734177215189873
          },
          {
            "name": "Eileen",
            "popularity": 1.5776699029126213
          },
          {
            "name": "Antoinette",
            "popularity": 1.5256410256410255
          },
          {
            "name": "Angelina",
            "popularity": 1.4615384615384615
          },
          {
            "name": "Rosemarie",
            "popularity": 1.4179104477611941
          },
          {
            "name": "Madeline",
            "popularity": 1.28
          },
          {
            "name": "Maureen",
            "popularity": 1.2674418604651163
          },
          {
            "name": "Marianne",
            "popularity": 1.2142857142857142
          },
          {
            "name": "Michele",
            "popularity": 1.1476014760147601
          },
          {
            "name": "Doreen",
            "popularity": 1.1384615384615384
          },
          {
            "name": "Joan",
            "popularity": 1.0298507462686568
          },
          {
            "name": "Eleanor",
            "popularity": 0.9929078014184397
          },
          {
            "name": "Marion",
            "popularity": 0.9710144927536232
          },
          {
            "name": "Sophie",
            "popularity": 0.9672131147540983
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Nicholas",
            "popularity": 2.1463414634146343
          },
          {
            "name": "Dominick",
            "popularity": 1.9607843137254901
          },
          {
            "name": "Angelo",
            "popularity": 1.9107142857142858
          },
          {
            "name": "Vincent",
            "popularity": 1.6712328767123288
          },
          {
            "name": "Peter",
            "popularity": 1.4923413566739605
          },
          {
            "name": "Alexander",
            "popularity": 1.2941176470588236
          },
          {
            "name": "Salvatore",
            "popularity": 1.288888888888889
          },
          {
            "name": "Anthony",
            "popularity": 1.2300884955752212
          },
          {
            "name": "Gerard",
            "popularity": 1.1666666666666667
          },
          {
            "name": "Joseph",
            "popularity": 1.1472868217054264
          },
          {
            "name": "Frank",
            "popularity": 0.9502824858757062
          },
          {
            "name": "Louis",
            "popularity": 0.9310344827586207
          },
          {
            "name": "Frederick",
            "popularity": 0.8032128514056225
          },
          {
            "name": "Edward",
            "popularity": 0.7849117174959872
          },
          {
            "name": "Theodore",
            "popularity": 0.7846153846153846
          }
        ]
      }
    ]
  },
  {
    "state": "NM",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Cecilia",
            "popularity": 6
          },
          {
            "name": "Ramona",
            "popularity": 4.694444444444445
          },
          {
            "name": "Carmen",
            "popularity": 4.421052631578948
          },
          {
            "name": "Bernadette",
            "popularity": 3.9649122807017543
          },
          {
            "name": "Maria",
            "popularity": 3.7816455696202533
          },
          {
            "name": "Lucy",
            "popularity": 3.595419847328244
          },
          {
            "name": "Priscilla",
            "popularity": 3.5625
          },
          {
            "name": "Flora",
            "popularity": 2.96875
          },
          {
            "name": "Yolanda",
            "popularity": 2.7714285714285714
          },
          {
            "name": "Dora",
            "popularity": 2.67032967032967
          },
          {
            "name": "Marcella",
            "popularity": 2.6451612903225805
          },
          {
            "name": "Lydia",
            "popularity": 2.4210526315789473
          },
          {
            "name": "Lupe",
            "popularity": 2.2222222222222223
          },
          {
            "name": "Stella",
            "popularity": 2.1610169491525424
          },
          {
            "name": "Rosie",
            "popularity": 2.1149425287356323
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Manuel",
            "popularity": 10.227272727272727
          },
          {
            "name": "Jose",
            "popularity": 7.42512077294686
          },
          {
            "name": "Antonio",
            "popularity": 5.476190476190476
          },
          {
            "name": "Gilbert",
            "popularity": 5.227642276422764
          },
          {
            "name": "Ruben",
            "popularity": 5.016393442622951
          },
          {
            "name": "Juan",
            "popularity": 4.84251968503937
          },
          {
            "name": "Carlos",
            "popularity": 4.2784810126582276
          },
          {
            "name": "Joe",
            "popularity": 3.8354978354978355
          },
          {
            "name": "Pedro",
            "popularity": 2.8870967741935485
          },
          {
            "name": "Alex",
            "popularity": 2.765625
          },
          {
            "name": "Luis",
            "popularity": 2.764705882352941
          },
          {
            "name": "Francisco",
            "popularity": 2.75
          },
          {
            "name": "Miguel",
            "popularity": 2.740740740740741
          },
          {
            "name": "Jesus",
            "popularity": 2.676470588235294
          },
          {
            "name": "Bennie",
            "popularity": 2.5172413793103448
          }
        ]
      }
    ]
  },
  {
    "state": "NV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Olga",
            "popularity": 5.102941176470588
          },
          {
            "name": "Traci",
            "popularity": 4.338709677419355
          },
          {
            "name": "Shannon",
            "popularity": 4.2
          },
          {
            "name": "Stacey",
            "popularity": 4.148148148148148
          },
          {
            "name": "Pat",
            "popularity": 3.9814814814814814
          },
          {
            "name": "Toni",
            "popularity": 3.1648351648351647
          },
          {
            "name": "Natalie",
            "popularity": 3.15
          },
          {
            "name": "Teri",
            "popularity": 3.014925373134328
          },
          {
            "name": "Kelli",
            "popularity": 2.981818181818182
          },
          {
            "name": "Marguerite",
            "popularity": 2.9473684210526314
          },
          {
            "name": "Tina",
            "popularity": 2.8875
          },
          {
            "name": "Blanche",
            "popularity": 2.7948717948717947
          },
          {
            "name": "Tami",
            "popularity": 2.746031746031746
          },
          {
            "name": "Nicole",
            "popularity": 2.7454545454545456
          },
          {
            "name": "Leslie",
            "popularity": 2.672727272727273
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jason",
            "popularity": 4.333333333333333
          },
          {
            "name": "Shawn",
            "popularity": 4.177966101694915
          },
          {
            "name": "Troy",
            "popularity": 4.022222222222222
          },
          {
            "name": "Kelly",
            "popularity": 3.736111111111111
          },
          {
            "name": "Woodrow",
            "popularity": 3.6538461538461537
          },
          {
            "name": "Lance",
            "popularity": 2.982142857142857
          },
          {
            "name": "Darren",
            "popularity": 2.711340206185567
          },
          {
            "name": "Mike",
            "popularity": 2.526086956521739
          },
          {
            "name": "Brent",
            "popularity": 2
          },
          {
            "name": "Adam",
            "popularity": 2
          },
          {
            "name": "Aaron",
            "popularity": 1.9864864864864864
          },
          {
            "name": "Darin",
            "popularity": 1.9622641509433962
          },
          {
            "name": "Brett",
            "popularity": 1.9589041095890412
          },
          {
            "name": "Delbert",
            "popularity": 1.8909090909090909
          },
          {
            "name": "Tracy",
            "popularity": 1.639344262295082
          }
        ]
      }
    ]
  },
  {
    "state": "NY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Antoinette",
            "popularity": 1.7564102564102564
          },
          {
            "name": "Eileen",
            "popularity": 1.674757281553398
          },
          {
            "name": "Madeline",
            "popularity": 1.6533333333333333
          },
          {
            "name": "Miriam",
            "popularity": 1.618421052631579
          },
          {
            "name": "Muriel",
            "popularity": 1.5671641791044777
          },
          {
            "name": "Angelina",
            "popularity": 1.5
          },
          {
            "name": "Rosemarie",
            "popularity": 1.462686567164179
          },
          {
            "name": "Maureen",
            "popularity": 1.3546511627906976
          },
          {
            "name": "Maryann",
            "popularity": 1.1578947368421053
          },
          {
            "name": "Marion",
            "popularity": 1
          },
          {
            "name": "Josephine",
            "popularity": 1
          },
          {
            "name": "Claire",
            "popularity": 0.9873417721518988
          },
          {
            "name": "Anne",
            "popularity": 0.9867109634551495
          },
          {
            "name": "Joan",
            "popularity": 0.9154228855721394
          },
          {
            "name": "Doreen",
            "popularity": 0.9076923076923077
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Salvatore",
            "popularity": 2.2222222222222223
          },
          {
            "name": "Angelo",
            "popularity": 2.0535714285714284
          },
          {
            "name": "Dominick",
            "popularity": 2.0392156862745097
          },
          {
            "name": "Vincent",
            "popularity": 1.9634703196347032
          },
          {
            "name": "Nicholas",
            "popularity": 1.7967479674796747
          },
          {
            "name": "Gerard",
            "popularity": 1.7916666666666667
          },
          {
            "name": "Peter",
            "popularity": 1.687089715536105
          },
          {
            "name": "Stuart",
            "popularity": 1.2096774193548387
          },
          {
            "name": "Anthony",
            "popularity": 1.1843657817109146
          },
          {
            "name": "Seymour",
            "popularity": 1.1111111111111112
          },
          {
            "name": "Alexander",
            "popularity": 1.035294117647059
          },
          {
            "name": "Martin",
            "popularity": 0.9146341463414634
          },
          {
            "name": "Neil",
            "popularity": 0.9078947368421053
          },
          {
            "name": "Philip",
            "popularity": 0.8896551724137931
          },
          {
            "name": "Louis",
            "popularity": 0.8488063660477454
          }
        ]
      }
    ]
  },
  {
    "state": "OH",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Beth",
            "popularity": 0.6778523489932886
          },
          {
            "name": "Patty",
            "popularity": 0.6506024096385542
          },
          {
            "name": "Sue",
            "popularity": 0.6379310344827587
          },
          {
            "name": "Amy",
            "popularity": 0.5906976744186047
          },
          {
            "name": "Marcella",
            "popularity": 0.5
          },
          {
            "name": "Dianna",
            "popularity": 0.45588235294117646
          },
          {
            "name": "Becky",
            "popularity": 0.44954128440366975
          },
          {
            "name": "Tonya",
            "popularity": 0.43333333333333335
          },
          {
            "name": "Kimberly",
            "popularity": 0.42205882352941176
          },
          {
            "name": "Rosemary",
            "popularity": 0.4117647058823529
          },
          {
            "name": "Marcia",
            "popularity": 0.3974358974358974
          },
          {
            "name": "Darla",
            "popularity": 0.39655172413793105
          },
          {
            "name": "Penny",
            "popularity": 0.3937007874015748
          },
          {
            "name": "Sandy",
            "popularity": 0.3924050632911392
          },
          {
            "name": "Marilyn",
            "popularity": 0.3897550111358575
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Rick",
            "popularity": 0.776
          },
          {
            "name": "Tim",
            "popularity": 0.7027027027027027
          },
          {
            "name": "Dave",
            "popularity": 0.6865671641791045
          },
          {
            "name": "Dale",
            "popularity": 0.5974025974025974
          },
          {
            "name": "Wilbur",
            "popularity": 0.5873015873015873
          },
          {
            "name": "Darrin",
            "popularity": 0.5192307692307693
          },
          {
            "name": "Jeffrey",
            "popularity": 0.4994152046783626
          },
          {
            "name": "Tom",
            "popularity": 0.4934210526315789
          },
          {
            "name": "Timothy",
            "popularity": 0.4813753581661891
          },
          {
            "name": "Jeffery",
            "popularity": 0.47520661157024796
          },
          {
            "name": "Jeff",
            "popularity": 0.423841059602649
          },
          {
            "name": "Ted",
            "popularity": 0.41025641025641024
          },
          {
            "name": "Karl",
            "popularity": 0.36904761904761907
          },
          {
            "name": "Carl",
            "popularity": 0.3557312252964427
          },
          {
            "name": "Dwight",
            "popularity": 0.35135135135135137
          }
        ]
      }
    ]
  },
  {
    "state": "OK",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Opal",
            "popularity": 4.134020618556701
          },
          {
            "name": "Billie",
            "popularity": 3.706422018348624
          },
          {
            "name": "Shelly",
            "popularity": 2.3962264150943398
          },
          {
            "name": "Velma",
            "popularity": 2.196078431372549
          },
          {
            "name": "Kristi",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Patsy",
            "popularity": 2.1538461538461537
          },
          {
            "name": "Darla",
            "popularity": 2.1379310344827585
          },
          {
            "name": "Wanda",
            "popularity": 2.1143695014662756
          },
          {
            "name": "Wilma",
            "popularity": 1.9310344827586208
          },
          {
            "name": "Geneva",
            "popularity": 1.7857142857142858
          },
          {
            "name": "Lola",
            "popularity": 1.7647058823529411
          },
          {
            "name": "Juanita",
            "popularity": 1.7043478260869565
          },
          {
            "name": "Erma",
            "popularity": 1.6818181818181819
          },
          {
            "name": "Kelli",
            "popularity": 1.6545454545454545
          },
          {
            "name": "Ruby",
            "popularity": 1.608695652173913
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Billy",
            "popularity": 3.13715710723192
          },
          {
            "name": "Jackie",
            "popularity": 2.7127659574468086
          },
          {
            "name": "Jimmie",
            "popularity": 2.5426356589147288
          },
          {
            "name": "Jimmy",
            "popularity": 2.367272727272727
          },
          {
            "name": "Tommy",
            "popularity": 2.2923976608187133
          },
          {
            "name": "Bill",
            "popularity": 2.2433862433862433
          },
          {
            "name": "Cecil",
            "popularity": 2.1478260869565218
          },
          {
            "name": "Bobby",
            "popularity": 2.110091743119266
          },
          {
            "name": "Delbert",
            "popularity": 2.036363636363636
          },
          {
            "name": "Bob",
            "popularity": 1.9642857142857142
          },
          {
            "name": "Virgil",
            "popularity": 1.8333333333333333
          },
          {
            "name": "Floyd",
            "popularity": 1.7515151515151515
          },
          {
            "name": "Rickey",
            "popularity": 1.6704545454545454
          },
          {
            "name": "Don",
            "popularity": 1.53475935828877
          },
          {
            "name": "Ronnie",
            "popularity": 1.471698113207547
          }
        ]
      }
    ]
  },
  {
    "state": "OR",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 3.0952380952380953
          },
          {
            "name": "Shannon",
            "popularity": 2.6470588235294117
          },
          {
            "name": "Shelley",
            "popularity": 1.9438202247191012
          },
          {
            "name": "Julie",
            "popularity": 1.912
          },
          {
            "name": "Kristi",
            "popularity": 1.9038461538461537
          },
          {
            "name": "Tamara",
            "popularity": 1.882882882882883
          },
          {
            "name": "Lucile",
            "popularity": 1.694915254237288
          },
          {
            "name": "Shelly",
            "popularity": 1.679245283018868
          },
          {
            "name": "Jan",
            "popularity": 1.5569620253164558
          },
          {
            "name": "Becky",
            "popularity": 1.4770642201834863
          },
          {
            "name": "Deanna",
            "popularity": 1.4485981308411215
          },
          {
            "name": "Kelli",
            "popularity": 1.4363636363636363
          },
          {
            "name": "Teri",
            "popularity": 1.4328358208955223
          },
          {
            "name": "Karla",
            "popularity": 1.4126984126984128
          },
          {
            "name": "Traci",
            "popularity": 1.3709677419354838
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Darin",
            "popularity": 2.981132075471698
          },
          {
            "name": "Woodrow",
            "popularity": 2.75
          },
          {
            "name": "Kelly",
            "popularity": 2.5694444444444446
          },
          {
            "name": "Rick",
            "popularity": 2.16
          },
          {
            "name": "Jason",
            "popularity": 2.0277777777777777
          },
          {
            "name": "Jim",
            "popularity": 1.8488372093023255
          },
          {
            "name": "Bob",
            "popularity": 1.7857142857142858
          },
          {
            "name": "Dan",
            "popularity": 1.7217391304347827
          },
          {
            "name": "Dave",
            "popularity": 1.6567164179104477
          },
          {
            "name": "Brad",
            "popularity": 1.6025641025641026
          },
          {
            "name": "Delbert",
            "popularity": 1.6
          },
          {
            "name": "Jeff",
            "popularity": 1.5827814569536425
          },
          {
            "name": "Mike",
            "popularity": 1.5608695652173914
          },
          {
            "name": "Lyle",
            "popularity": 1.5238095238095237
          },
          {
            "name": "Bradley",
            "popularity": 1.5121951219512195
          }
        ]
      }
    ]
  },
  {
    "state": "PA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Anna",
            "popularity": 1.387900355871886
          },
          {
            "name": "Dolores",
            "popularity": 1.1302681992337165
          },
          {
            "name": "Maryann",
            "popularity": 1.0526315789473684
          },
          {
            "name": "Eleanor",
            "popularity": 0.9787234042553191
          },
          {
            "name": "Miriam",
            "popularity": 0.9736842105263158
          },
          {
            "name": "Bernadette",
            "popularity": 0.9649122807017544
          },
          {
            "name": "Marian",
            "popularity": 0.7484276729559748
          },
          {
            "name": "Sophie",
            "popularity": 0.7377049180327869
          },
          {
            "name": "Rosemarie",
            "popularity": 0.7164179104477612
          },
          {
            "name": "Agnes",
            "popularity": 0.7114093959731543
          },
          {
            "name": "Helen",
            "popularity": 0.6921692169216922
          },
          {
            "name": "Florence",
            "popularity": 0.6865203761755486
          },
          {
            "name": "Stella",
            "popularity": 0.6271186440677966
          },
          {
            "name": "Joanne",
            "popularity": 0.6220472440944882
          },
          {
            "name": "Marianne",
            "popularity": 0.6
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Francis",
            "popularity": 1.394648829431438
          },
          {
            "name": "Harry",
            "popularity": 1.1466346153846154
          },
          {
            "name": "Joseph",
            "popularity": 1.012735326688815
          },
          {
            "name": "Nicholas",
            "popularity": 0.9186991869918699
          },
          {
            "name": "Barry",
            "popularity": 0.7129629629629629
          },
          {
            "name": "Bernard",
            "popularity": 0.6682242990654206
          },
          {
            "name": "Vincent",
            "popularity": 0.5981735159817352
          },
          {
            "name": "Edward",
            "popularity": 0.5947030497592295
          },
          {
            "name": "Andrew",
            "popularity": 0.5558659217877095
          },
          {
            "name": "Samuel",
            "popularity": 0.5517241379310345
          },
          {
            "name": "Theodore",
            "popularity": 0.5282051282051282
          },
          {
            "name": "Alexander",
            "popularity": 0.4823529411764706
          },
          {
            "name": "Albert",
            "popularity": 0.46331236897274636
          },
          {
            "name": "Stanley",
            "popularity": 0.4523076923076923
          },
          {
            "name": "Frank",
            "popularity": 0.4406779661016949
          }
        ]
      }
    ]
  },
  {
    "state": "RI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Claire",
            "popularity": 7.050632911392405
          },
          {
            "name": "Kristen",
            "popularity": 4.245283018867925
          },
          {
            "name": "Muriel",
            "popularity": 4.164179104477612
          },
          {
            "name": "Angelina",
            "popularity": 4
          },
          {
            "name": "Doreen",
            "popularity": 3.4
          },
          {
            "name": "Maureen",
            "popularity": 3.2209302325581395
          },
          {
            "name": "Jeannette",
            "popularity": 3.014705882352941
          },
          {
            "name": "Madeline",
            "popularity": 2.48
          },
          {
            "name": "Flora",
            "popularity": 2.3125
          },
          {
            "name": "Jennie",
            "popularity": 2.288659793814433
          },
          {
            "name": "Gertrude",
            "popularity": 2.2083333333333335
          },
          {
            "name": "Laurie",
            "popularity": 2.103139013452915
          },
          {
            "name": "Gail",
            "popularity": 2.0113636363636362
          },
          {
            "name": "Olga",
            "popularity": 1.9558823529411764
          },
          {
            "name": "Sophie",
            "popularity": 1.9508196721311475
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Roland",
            "popularity": 4.2631578947368425
          },
          {
            "name": "Gerard",
            "popularity": 3.1666666666666665
          },
          {
            "name": "Normand",
            "popularity": 2.9012345679012346
          },
          {
            "name": "Angelo",
            "popularity": 2.357142857142857
          },
          {
            "name": "Leo",
            "popularity": 2.3067484662576687
          },
          {
            "name": "Marc",
            "popularity": 2.276190476190476
          },
          {
            "name": "Alfred",
            "popularity": 1.9681274900398407
          },
          {
            "name": "Peter",
            "popularity": 1.8905908096280089
          },
          {
            "name": "Manuel",
            "popularity": 1.8181818181818181
          },
          {
            "name": "Raymond",
            "popularity": 1.7651715039577835
          },
          {
            "name": "Francis",
            "popularity": 1.6421404682274248
          },
          {
            "name": "Maurice",
            "popularity": 1.5510204081632653
          },
          {
            "name": "Vincent",
            "popularity": 1.5205479452054795
          },
          {
            "name": "Antonio",
            "popularity": 1.4761904761904763
          },
          {
            "name": "Anthony",
            "popularity": 1.3215339233038348
          }
        ]
      }
    ]
  },
  {
    "state": "SC",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Hattie",
            "popularity": 4.223529411764706
          },
          {
            "name": "Rosa",
            "popularity": 4.093525179856115
          },
          {
            "name": "Maggie",
            "popularity": 3.984375
          },
          {
            "name": "Janie",
            "popularity": 3.948717948717949
          },
          {
            "name": "Annie",
            "popularity": 3.8161993769470404
          },
          {
            "name": "Mamie",
            "popularity": 3.7534246575342465
          },
          {
            "name": "Daisy",
            "popularity": 3.5428571428571427
          },
          {
            "name": "Lillie",
            "popularity": 3.5167785234899327
          },
          {
            "name": "Sadie",
            "popularity": 3.125
          },
          {
            "name": "Carrie",
            "popularity": 3.1142857142857143
          },
          {
            "name": "Essie",
            "popularity": 2.803921568627451
          },
          {
            "name": "Lula",
            "popularity": 2.6904761904761907
          },
          {
            "name": "Mattie",
            "popularity": 2.6296296296296298
          },
          {
            "name": "Willie",
            "popularity": 2.4060913705583755
          },
          {
            "name": "Jessie",
            "popularity": 2.265625
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Marion",
            "popularity": 4.875
          },
          {
            "name": "Nathaniel",
            "popularity": 4.375
          },
          {
            "name": "Willie",
            "popularity": 3.9478079331941545
          },
          {
            "name": "Roosevelt",
            "popularity": 3.3333333333333335
          },
          {
            "name": "Woodrow",
            "popularity": 2.826923076923077
          },
          {
            "name": "Luther",
            "popularity": 2.716417910447761
          },
          {
            "name": "Johnnie",
            "popularity": 2.5892857142857144
          },
          {
            "name": "Julius",
            "popularity": 2.5714285714285716
          },
          {
            "name": "Leroy",
            "popularity": 2.511627906976744
          },
          {
            "name": "Charlie",
            "popularity": 2.4055944055944054
          },
          {
            "name": "Bennie",
            "popularity": 2.3448275862068964
          },
          {
            "name": "Freddie",
            "popularity": 2.1538461538461537
          },
          {
            "name": "Otis",
            "popularity": 2.1333333333333333
          },
          {
            "name": "Horace",
            "popularity": 2.096774193548387
          },
          {
            "name": "Ben",
            "popularity": 1.7611940298507462
          }
        ]
      }
    ]
  },
  {
    "state": "SD",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristi",
            "popularity": 4.403846153846154
          },
          {
            "name": "Karla",
            "popularity": 3.9365079365079363
          },
          {
            "name": "Darla",
            "popularity": 3.3620689655172415
          },
          {
            "name": "Tamara",
            "popularity": 2.774774774774775
          },
          {
            "name": "Jody",
            "popularity": 2.611940298507463
          },
          {
            "name": "Violet",
            "popularity": 2.5660377358490565
          },
          {
            "name": "Mabel",
            "popularity": 2.5588235294117645
          },
          {
            "name": "Kay",
            "popularity": 2.520661157024793
          },
          {
            "name": "Delores",
            "popularity": 2.439189189189189
          },
          {
            "name": "Maxine",
            "popularity": 2.3484848484848486
          },
          {
            "name": "Verna",
            "popularity": 2.2837837837837838
          },
          {
            "name": "Viola",
            "popularity": 2.28125
          },
          {
            "name": "Olive",
            "popularity": 2.173076923076923
          },
          {
            "name": "Leona",
            "popularity": 2.169811320754717
          },
          {
            "name": "Lana",
            "popularity": 2.0784313725490198
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Lyle",
            "popularity": 7.285714285714286
          },
          {
            "name": "Darin",
            "popularity": 4.962264150943396
          },
          {
            "name": "Kelly",
            "popularity": 4.236111111111111
          },
          {
            "name": "Duane",
            "popularity": 4.088709677419355
          },
          {
            "name": "Bradley",
            "popularity": 3.2113821138211383
          },
          {
            "name": "Brad",
            "popularity": 2.628205128205128
          },
          {
            "name": "Troy",
            "popularity": 2.5555555555555554
          },
          {
            "name": "Todd",
            "popularity": 2.4306569343065694
          },
          {
            "name": "Delbert",
            "popularity": 2.3636363636363638
          },
          {
            "name": "Dean",
            "popularity": 2.301282051282051
          },
          {
            "name": "Dale",
            "popularity": 2.2305194805194803
          },
          {
            "name": "Elmer",
            "popularity": 1.9090909090909092
          },
          {
            "name": "Daryl",
            "popularity": 1.896551724137931
          },
          {
            "name": "Kim",
            "popularity": 1.8620689655172413
          },
          {
            "name": "Virgil",
            "popularity": 1.858974358974359
          }
        ]
      }
    ]
  },
  {
    "state": "TN",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Shelia",
            "popularity": 2.7721518987341773
          },
          {
            "name": "Bobbie",
            "popularity": 1.82
          },
          {
            "name": "Wilma",
            "popularity": 1.5689655172413792
          },
          {
            "name": "Ruby",
            "popularity": 1.562111801242236
          },
          {
            "name": "Patsy",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Billie",
            "popularity": 1.4770642201834863
          },
          {
            "name": "Mattie",
            "popularity": 1.451851851851852
          },
          {
            "name": "Glenda",
            "popularity": 1.4027777777777777
          },
          {
            "name": "Geneva",
            "popularity": 1.3979591836734695
          },
          {
            "name": "Willie",
            "popularity": 1.3908629441624365
          },
          {
            "name": "Maggie",
            "popularity": 1.375
          },
          {
            "name": "Melissa",
            "popularity": 1.251082251082251
          },
          {
            "name": "Wanda",
            "popularity": 1.2287390029325513
          },
          {
            "name": "Tonya",
            "popularity": 1.211111111111111
          },
          {
            "name": "Johnnie",
            "popularity": 1.2027027027027026
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Billy",
            "popularity": 2.3840399002493764
          },
          {
            "name": "Jackie",
            "popularity": 2.265957446808511
          },
          {
            "name": "Bobby",
            "popularity": 2.217125382262997
          },
          {
            "name": "Rickey",
            "popularity": 2.0113636363636362
          },
          {
            "name": "Donnie",
            "popularity": 1.9701492537313432
          },
          {
            "name": "Jimmy",
            "popularity": 1.8945454545454545
          },
          {
            "name": "Ronnie",
            "popularity": 1.721698113207547
          },
          {
            "name": "Hubert",
            "popularity": 1.6
          },
          {
            "name": "Luther",
            "popularity": 1.5970149253731343
          },
          {
            "name": "Claude",
            "popularity": 1.5384615384615385
          },
          {
            "name": "Tommy",
            "popularity": 1.5029239766081872
          },
          {
            "name": "Johnny",
            "popularity": 1.4817518248175183
          },
          {
            "name": "Ricky",
            "popularity": 1.4793103448275862
          },
          {
            "name": "Hugh",
            "popularity": 1.4050632911392404
          },
          {
            "name": "Charlie",
            "popularity": 1.2797202797202798
          }
        ]
      }
    ]
  },
  {
    "state": "TX",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Maria",
            "popularity": 5.031645569620253
          },
          {
            "name": "Guadalupe",
            "popularity": 2.7444444444444445
          },
          {
            "name": "Yolanda",
            "popularity": 2.6952380952380954
          },
          {
            "name": "Billie",
            "popularity": 2.4954128440366974
          },
          {
            "name": "Irma",
            "popularity": 2.364864864864865
          },
          {
            "name": "Rosa",
            "popularity": 2.338129496402878
          },
          {
            "name": "Alicia",
            "popularity": 2.303030303030303
          },
          {
            "name": "Janie",
            "popularity": 2.1794871794871793
          },
          {
            "name": "Dora",
            "popularity": 1.835164835164835
          },
          {
            "name": "Olga",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Bobbie",
            "popularity": 1.6
          },
          {
            "name": "Patsy",
            "popularity": 1.5961538461538463
          },
          {
            "name": "Carmen",
            "popularity": 1.5894736842105264
          },
          {
            "name": "Lydia",
            "popularity": 1.5789473684210527
          },
          {
            "name": "Juanita",
            "popularity": 1.5521739130434782
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Juan",
            "popularity": 5.606299212598425
          },
          {
            "name": "Jose",
            "popularity": 4.903381642512077
          },
          {
            "name": "Ruben",
            "popularity": 4.508196721311475
          },
          {
            "name": "Manuel",
            "popularity": 4.036363636363636
          },
          {
            "name": "Jesus",
            "popularity": 3.764705882352941
          },
          {
            "name": "Pedro",
            "popularity": 3.6774193548387095
          },
          {
            "name": "Roberto",
            "popularity": 3.6176470588235294
          },
          {
            "name": "Ricardo",
            "popularity": 3.5272727272727273
          },
          {
            "name": "Raul",
            "popularity": 3.4927536231884058
          },
          {
            "name": "Carlos",
            "popularity": 3.3164556962025316
          },
          {
            "name": "Francisco",
            "popularity": 3.3088235294117645
          },
          {
            "name": "Antonio",
            "popularity": 3.2738095238095237
          },
          {
            "name": "Hector",
            "popularity": 2.5283018867924527
          },
          {
            "name": "Guadalupe",
            "popularity": 2.476923076923077
          },
          {
            "name": "Joe",
            "popularity": 2.1277056277056277
          }
        ]
      }
    ]
  },
  {
    "state": "UT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Robyn",
            "popularity": 5.60377358490566
          },
          {
            "name": "Sherrie",
            "popularity": 4.568627450980392
          },
          {
            "name": "Kristine",
            "popularity": 3.340909090909091
          },
          {
            "name": "Erma",
            "popularity": 3.1818181818181817
          },
          {
            "name": "Natalie",
            "popularity": 3.1666666666666665
          },
          {
            "name": "Becky",
            "popularity": 3.0275229357798166
          },
          {
            "name": "Colleen",
            "popularity": 3.0141843971631204
          },
          {
            "name": "Jan",
            "popularity": 2.949367088607595
          },
          {
            "name": "Julie",
            "popularity": 2.7466666666666666
          },
          {
            "name": "Jody",
            "popularity": 2.373134328358209
          },
          {
            "name": "Heidi",
            "popularity": 2.303030303030303
          },
          {
            "name": "Lucile",
            "popularity": 2.2203389830508473
          },
          {
            "name": "Leslie",
            "popularity": 2.175757575757576
          },
          {
            "name": "Teri",
            "popularity": 2.1044776119402986
          },
          {
            "name": "Shelly",
            "popularity": 2.0943396226415096
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Brent",
            "popularity": 10.182926829268293
          },
          {
            "name": "Lynn",
            "popularity": 9
          },
          {
            "name": "Kelly",
            "popularity": 7.111111111111111
          },
          {
            "name": "Kent",
            "popularity": 7.070422535211268
          },
          {
            "name": "Kim",
            "popularity": 5.931034482758621
          },
          {
            "name": "Darin",
            "popularity": 5.528301886792453
          },
          {
            "name": "Woodrow",
            "popularity": 5.365384615384615
          },
          {
            "name": "Brad",
            "popularity": 4.5
          },
          {
            "name": "Max",
            "popularity": 4.136986301369863
          },
          {
            "name": "Troy",
            "popularity": 4.029629629629629
          },
          {
            "name": "Rex",
            "popularity": 3.9298245614035086
          },
          {
            "name": "Tracy",
            "popularity": 3.2459016393442623
          },
          {
            "name": "Kerry",
            "popularity": 3.0344827586206895
          },
          {
            "name": "Don",
            "popularity": 2.978609625668449
          },
          {
            "name": "Jay",
            "popularity": 2.9545454545454546
          }
        ]
      }
    ]
  },
  {
    "state": "VA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Nannie",
            "popularity": 1.721311475409836
          },
          {
            "name": "Vanessa",
            "popularity": 1.510204081632653
          },
          {
            "name": "Rosa",
            "popularity": 1.330935251798561
          },
          {
            "name": "Shelia",
            "popularity": 1.3291139240506329
          },
          {
            "name": "Lucy",
            "popularity": 1.2290076335877862
          },
          {
            "name": "Fannie",
            "popularity": 1.0617283950617284
          },
          {
            "name": "Elsie",
            "popularity": 1.0545454545454545
          },
          {
            "name": "Susie",
            "popularity": 1.051948051948052
          },
          {
            "name": "Thelma",
            "popularity": 0.9695817490494296
          },
          {
            "name": "Hattie",
            "popularity": 0.9647058823529412
          },
          {
            "name": "Iris",
            "popularity": 0.9642857142857143
          },
          {
            "name": "Nellie",
            "popularity": 0.9618320610687023
          },
          {
            "name": "Angela",
            "popularity": 0.9276729559748428
          },
          {
            "name": "Virginia",
            "popularity": 0.9216216216216216
          },
          {
            "name": "Estelle",
            "popularity": 0.9090909090909091
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Charlie",
            "popularity": 1.7622377622377623
          },
          {
            "name": "Clifton",
            "popularity": 1.7
          },
          {
            "name": "Claude",
            "popularity": 1.6263736263736264
          },
          {
            "name": "Lewis",
            "popularity": 1.4722222222222223
          },
          {
            "name": "Luther",
            "popularity": 1.4029850746268657
          },
          {
            "name": "Calvin",
            "popularity": 1.2380952380952381
          },
          {
            "name": "Earnest",
            "popularity": 1.1911764705882353
          },
          {
            "name": "Otis",
            "popularity": 1.1833333333333333
          },
          {
            "name": "Marshall",
            "popularity": 1.1147540983606556
          },
          {
            "name": "Cecil",
            "popularity": 1.1130434782608696
          },
          {
            "name": "Nelson",
            "popularity": 1.0892857142857142
          },
          {
            "name": "Reginald",
            "popularity": 1.0506329113924051
          },
          {
            "name": "Franklin",
            "popularity": 1.0327868852459017
          },
          {
            "name": "Woodrow",
            "popularity": 1.0192307692307692
          },
          {
            "name": "Clarence",
            "popularity": 0.9739413680781759
          }
        ]
      }
    ]
  },
  {
    "state": "VT",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Madeline",
            "popularity": 4.8
          },
          {
            "name": "Marion",
            "popularity": 4.1352657004830915
          },
          {
            "name": "Laurie",
            "popularity": 4.013452914798206
          },
          {
            "name": "Blanche",
            "popularity": 3.9358974358974357
          },
          {
            "name": "Claire",
            "popularity": 3.481012658227848
          },
          {
            "name": "Olive",
            "popularity": 3
          },
          {
            "name": "Priscilla",
            "popularity": 2.9125
          },
          {
            "name": "Heather",
            "popularity": 2.835294117647059
          },
          {
            "name": "Heidi",
            "popularity": 2.7373737373737375
          },
          {
            "name": "Penny",
            "popularity": 2.2755905511811023
          },
          {
            "name": "Marguerite",
            "popularity": 2.2736842105263158
          },
          {
            "name": "Pauline",
            "popularity": 2.2730923694779115
          },
          {
            "name": "Muriel",
            "popularity": 2.2686567164179103
          },
          {
            "name": "Tina",
            "popularity": 2.245833333333333
          },
          {
            "name": "Jeannette",
            "popularity": 2.161764705882353
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jason",
            "popularity": 4.138888888888889
          },
          {
            "name": "Reginald",
            "popularity": 3.6962025316455698
          },
          {
            "name": "Maurice",
            "popularity": 3.693877551020408
          },
          {
            "name": "Roland",
            "popularity": 3.3684210526315788
          },
          {
            "name": "Dana",
            "popularity": 3.314814814814815
          },
          {
            "name": "Wendell",
            "popularity": 2.7169811320754715
          },
          {
            "name": "Francis",
            "popularity": 2.6354515050167224
          },
          {
            "name": "Bernard",
            "popularity": 2.4953271028037385
          },
          {
            "name": "Gordon",
            "popularity": 2.4578313253012047
          },
          {
            "name": "Everett",
            "popularity": 2.2435897435897436
          },
          {
            "name": "Sean",
            "popularity": 2.1512605042016806
          },
          {
            "name": "Shawn",
            "popularity": 2.1440677966101696
          },
          {
            "name": "Clayton",
            "popularity": 2
          },
          {
            "name": "Kim",
            "popularity": 1.793103448275862
          },
          {
            "name": "Todd",
            "popularity": 1.7627737226277371
          }
        ]
      }
    ]
  },
  {
    "state": "WA",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Tami",
            "popularity": 2.9682539682539684
          },
          {
            "name": "Shannon",
            "popularity": 2.2
          },
          {
            "name": "Kristi",
            "popularity": 1.7884615384615385
          },
          {
            "name": "Heidi",
            "popularity": 1.707070707070707
          },
          {
            "name": "Olive",
            "popularity": 1.6730769230769231
          },
          {
            "name": "Shelley",
            "popularity": 1.6629213483146068
          },
          {
            "name": "Kelli",
            "popularity": 1.6545454545454545
          },
          {
            "name": "Colleen",
            "popularity": 1.6453900709219857
          },
          {
            "name": "Kristine",
            "popularity": 1.5
          },
          {
            "name": "Teri",
            "popularity": 1.3880597014925373
          },
          {
            "name": "Pat",
            "popularity": 1.2592592592592593
          },
          {
            "name": "Tamara",
            "popularity": 1.2342342342342343
          },
          {
            "name": "Gayle",
            "popularity": 1.1375
          },
          {
            "name": "Julie",
            "popularity": 1.1333333333333333
          },
          {
            "name": "Deanna",
            "popularity": 1.1214953271028036
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Kelly",
            "popularity": 2.236111111111111
          },
          {
            "name": "Woodrow",
            "popularity": 2.1923076923076925
          },
          {
            "name": "Rick",
            "popularity": 2.04
          },
          {
            "name": "Dave",
            "popularity": 2
          },
          {
            "name": "Bob",
            "popularity": 1.9285714285714286
          },
          {
            "name": "Jim",
            "popularity": 1.8488372093023255
          },
          {
            "name": "Dan",
            "popularity": 1.7652173913043478
          },
          {
            "name": "Jason",
            "popularity": 1.6666666666666667
          },
          {
            "name": "Jeff",
            "popularity": 1.6291390728476822
          },
          {
            "name": "Mike",
            "popularity": 1.5695652173913044
          },
          {
            "name": "Brad",
            "popularity": 1.3717948717948718
          },
          {
            "name": "Gordon",
            "popularity": 1.355421686746988
          },
          {
            "name": "Greg",
            "popularity": 1.3545454545454545
          },
          {
            "name": "Bill",
            "popularity": 1.2804232804232805
          },
          {
            "name": "Jon",
            "popularity": 1.2137931034482758
          }
        ]
      }
    ]
  },
  {
    "state": "WI",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Kristine",
            "popularity": 2.8295454545454546
          },
          {
            "name": "Laverne",
            "popularity": 2.4545454545454546
          },
          {
            "name": "Jodi",
            "popularity": 1.7840909090909092
          },
          {
            "name": "Marcella",
            "popularity": 1.7258064516129032
          },
          {
            "name": "Kristin",
            "popularity": 1.328358208955224
          },
          {
            "name": "Lynn",
            "popularity": 1.3274336283185841
          },
          {
            "name": "Sophie",
            "popularity": 1.278688524590164
          },
          {
            "name": "Kay",
            "popularity": 1.2231404958677685
          },
          {
            "name": "Julie",
            "popularity": 1.1573333333333333
          },
          {
            "name": "Jody",
            "popularity": 1.1343283582089552
          },
          {
            "name": "Lorraine",
            "popularity": 1.0772357723577235
          },
          {
            "name": "Violet",
            "popularity": 1.0566037735849056
          },
          {
            "name": "Jill",
            "popularity": 1.0336538461538463
          },
          {
            "name": "Arlene",
            "popularity": 1.0123456790123457
          },
          {
            "name": "Audrey",
            "popularity": 0.946236559139785
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jerome",
            "popularity": 2.1073825503355703
          },
          {
            "name": "Lyle",
            "popularity": 2.0317460317460316
          },
          {
            "name": "Todd",
            "popularity": 1.8065693430656935
          },
          {
            "name": "Duane",
            "popularity": 1.6370967741935485
          },
          {
            "name": "Dean",
            "popularity": 1.3846153846153846
          },
          {
            "name": "Kurt",
            "popularity": 1.3837209302325582
          },
          {
            "name": "Gordon",
            "popularity": 1.216867469879518
          },
          {
            "name": "Dale",
            "popularity": 1.155844155844156
          },
          {
            "name": "Jon",
            "popularity": 1.1310344827586207
          },
          {
            "name": "Allan",
            "popularity": 1.1294117647058823
          },
          {
            "name": "Gerald",
            "popularity": 1.089795918367347
          },
          {
            "name": "Scott",
            "popularity": 1.077798861480076
          },
          {
            "name": "Arnold",
            "popularity": 0.9196428571428571
          },
          {
            "name": "Gregg",
            "popularity": 0.8823529411764706
          },
          {
            "name": "Jeffrey",
            "popularity": 0.8058479532163743
          }
        ]
      }
    ]
  },
  {
    "state": "WV",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Patty",
            "popularity": 2.2409638554216866
          },
          {
            "name": "Opal",
            "popularity": 1.9690721649484537
          },
          {
            "name": "Dianna",
            "popularity": 1.7794117647058822
          },
          {
            "name": "Beulah",
            "popularity": 1.7790697674418605
          },
          {
            "name": "Violet",
            "popularity": 1.7735849056603774
          },
          {
            "name": "Mabel",
            "popularity": 1.6764705882352942
          },
          {
            "name": "Naomi",
            "popularity": 1.6071428571428572
          },
          {
            "name": "Nellie",
            "popularity": 1.4809160305343512
          },
          {
            "name": "Della",
            "popularity": 1.3859649122807018
          },
          {
            "name": "Tammy",
            "popularity": 1.3540489642184557
          },
          {
            "name": "Wilma",
            "popularity": 1.339080459770115
          },
          {
            "name": "Sherri",
            "popularity": 1.1507936507936507
          },
          {
            "name": "Nina",
            "popularity": 1.1375
          },
          {
            "name": "Thelma",
            "popularity": 1.1216730038022813
          },
          {
            "name": "Maxine",
            "popularity": 1.053030303030303
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Jackie",
            "popularity": 2.606382978723404
          },
          {
            "name": "Delbert",
            "popularity": 2.2
          },
          {
            "name": "Homer",
            "popularity": 2.0428571428571427
          },
          {
            "name": "Franklin",
            "popularity": 2
          },
          {
            "name": "Woodrow",
            "popularity": 1.6538461538461537
          },
          {
            "name": "Cecil",
            "popularity": 1.6521739130434783
          },
          {
            "name": "Virgil",
            "popularity": 1.5897435897435896
          },
          {
            "name": "Willard",
            "popularity": 1.423529411764706
          },
          {
            "name": "Everett",
            "popularity": 1.2820512820512822
          },
          {
            "name": "Dana",
            "popularity": 1.2592592592592593
          },
          {
            "name": "Clyde",
            "popularity": 1.185430463576159
          },
          {
            "name": "Roger",
            "popularity": 1.1085106382978724
          },
          {
            "name": "Danny",
            "popularity": 1.0357142857142858
          },
          {
            "name": "Luther",
            "popularity": 1.0149253731343284
          },
          {
            "name": "Lewis",
            "popularity": 1.0069444444444444
          }
        ]
      }
    ]
  },
  {
    "state": "WY",
    "by_gender": [
      {
        "gender": "F",
        "by_name": [
          {
            "name": "Pat",
            "popularity": 3.074074074074074
          },
          {
            "name": "Shannon",
            "popularity": 2.8941176470588235
          },
          {
            "name": "Becky",
            "popularity": 2.7981651376146788
          },
          {
            "name": "Shelley",
            "popularity": 2.550561797752809
          },
          {
            "name": "Natalie",
            "popularity": 2.4833333333333334
          },
          {
            "name": "Jody",
            "popularity": 2.417910447761194
          },
          {
            "name": "Jamie",
            "popularity": 2.3661971830985915
          },
          {
            "name": "Stacy",
            "popularity": 2.313131313131313
          },
          {
            "name": "Agnes",
            "popularity": 2.2885906040268456
          },
          {
            "name": "Shelly",
            "popularity": 2.1037735849056602
          },
          {
            "name": "Violet",
            "popularity": 2.0943396226415096
          },
          {
            "name": "Olive",
            "popularity": 2
          },
          {
            "name": "Laurie",
            "popularity": 1.9820627802690582
          },
          {
            "name": "Hazel",
            "popularity": 1.974025974025974
          },
          {
            "name": "Opal",
            "popularity": 1.9278350515463918
          }
        ]
      },
      {
        "gender": "M",
        "by_name": [
          {
            "name": "Troy",
            "popularity": 5.940740740740741
          },
          {
            "name": "Jason",
            "popularity": 4.430555555555555
          },
          {
            "name": "Kelly",
            "popularity": 3.75
          },
          {
            "name": "Kim",
            "popularity": 3.5517241379310347
          },
          {
            "name": "Brad",
            "popularity": 3.1923076923076925
          },
          {
            "name": "Kent",
            "popularity": 2.9014084507042255
          },
          {
            "name": "Woodrow",
            "popularity": 2.5961538461538463
          },
          {
            "name": "Brett",
            "popularity": 2.547945205479452
          },
          {
            "name": "Lance",
            "popularity": 2.5357142857142856
          },
          {
            "name": "Bob",
            "popularity": 2.2767857142857144
          },
          {
            "name": "Darin",
            "popularity": 2.0377358490566038
          },
          {
            "name": "Jim",
            "popularity": 1.9593023255813953
          },
          {
            "name": "Bill",
            "popularity": 1.693121693121693
          },
          {
            "name": "Darren",
            "popularity": 1.6701030927835052
          },
          {
            "name": "Bradley",
            "popularity": 1.6585365853658536
          }
        ]
      }
    ]
  }
]
WITH __stage0 AS (
  SELECT
    group_set,
    (floor(base.year/10))*10 as decade__0,
    base.state as state__0,
    CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0,
    base.gender as gender__0,
    CASE WHEN group_set=0 THEN
      SUM(base.number)
      END as cohort_population__0,
    CASE WHEN group_set=1 THEN
      base.name
      END as name__1,
    CASE WHEN group_set=1 THEN
      SUM(base.number)
      END as population__1
  FROM `bigquery-public-data.usa_names.usa_1910_current` as base
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  GROUP BY 1,2,3,4,5,7
)
, __stage1 AS (
  SELECT
    decade__0 as decade,
    state__0 as state,
    baby_gender__0 as baby_gender,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
      name__1 as name, 
      population__1 as population
      ) END IGNORE NULLS  ORDER BY  population__1 desc ) as by_name
  FROM __stage0
  GROUP BY 1,2,3,4
  ORDER BY 5 desc
)
, __stage2 AS (
  SELECT
    group_set,
    concat(by_name_0.name,'') as name__0,
    names.gender as gender__0,
    CASE WHEN group_set=0 THEN
      floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000)
      END as births_per_100k__0,
    CASE WHEN group_set=1 THEN
      names.state
      END as state__1,
    CASE WHEN group_set=1 THEN
      floor((SUM(by_name_0.population)/CAST((
      (
        SUM(DISTINCT
          (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) +
          (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001
        ))
        -
         SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001)
      )/(1*1.0)) as FLOAT64))*100000)
      END as births_per_100k__1
  FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names
  LEFT JOIN UNNEST(names.by_name) as by_name_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,1,1)))
  WHERE names.decade<1970
  GROUP BY 1,2,3,5
)
, __stage3 AS (
  SELECT
    name__0 as name,
    gender__0 as gender,
    ANY_VALUE(CASE WHEN group_set=0 THEN births_per_100k__0 END) as births_per_100k,
    ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
      state__1 as state, 
      births_per_100k__1 as births_per_100k
      ) END IGNORE NULLS  ORDER BY  births_per_100k__1 desc ) as by_state
  FROM __stage2
  GROUP BY 1,2
  ORDER BY 3 desc
)
, __stage4 AS (
  SELECT
    group_set,
    by_state_0.state as state__0,
    CASE WHEN group_set IN (1,2) THEN
      base.gender
      END as gender__1,
    CASE WHEN group_set=2 THEN
      base.name
      END as name__2,
    CASE WHEN group_set=2 THEN
      ((by_state_0.births_per_100k-base.births_per_100k))/base.births_per_100k
      END as popularity__2
  FROM `__stage3` as base
  LEFT JOIN UNNEST(base.by_state) as by_state_0
  CROSS JOIN (SELECT row_number() OVER() -1  group_set FROM UNNEST(GENERATE_ARRAY(0,2,1)))
  WHERE base.births_per_100k>50
  GROUP BY 1,2,3,4,5
)
, __stage5 AS (
  SELECT 
    CASE WHEN group_set=2 THEN 1  ELSE group_set END as group_set,
    state__0 as state__0,
    CASE WHEN group_set IN (1,2) THEN
      gender__1
      END as gender__1,
    ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT(
      name__2 as name, 
      popularity__2 as popularity
      ) END IGNORE NULLS  ORDER BY  popularity__2 desc  LIMIT 15) as by_name__1
  FROM __stage4
  GROUP BY 1,2,3
)
SELECT
  state__0 as state,
  ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT(
    gender__1 as gender, 
    by_name__1 as by_name
    ) END IGNORE NULLS  ORDER BY  gender__1 asc ) as by_gender
FROM __stage5
GROUP BY 1
ORDER BY 1 asc